Average function in rtf template
Hi Friends , In this port , we will be discuss about average function in rtf template. We can calculate the average amount using some important functions in rtf template. Here below , we will be try to calculate the average function in rtf template. Please find below the complete details about average function in rtf template.
Step by Step to use Average function in rtf template
Step1: - For Example , Here below is the sample XML. In this we have Department name and the Total Salary for the Department. Now we need to calculate the average salary for all departments.
Step2:- Here below , we need to sum the total salary for all departments using this below syntax.
<?sum(current-group()/DEPT_SALARY)?>
Step3:- Here below , we need to count the total salary for all departments using this below syntax.
<?count(current-group()/DEPT)?>
Step4:- Using this below syntax to calculate the Average function in rtf template
<?sum(current-group()/DEPT_SALARY) div count(current-group()/DEPT)?>
0 comments:
Post a Comment