on 03-15-2019 8:53 AM
Hi,
I am trying to develop a crystal report using cross tab.
I want to add summary fields in the bottom section of report such as Average/Sum/Min/Max and other custom calculation for the column wise data which has been populated via cross tab expert columns.
Average or Std Deviation functions are available in the summary fields of the Cross tab expert.However i am not able to add a custom formula or use it in the summarized field.
The custom formula value is dependent on the Average value and Min value of the entire column.
The formula goes this was:Std Deviation*100/AVG
Could you please help me in inserting this formula in my cross tab which will be common for the rest of the columns too.
Please refer the following snapshot for the same:
Please help as i am stuck on this point!
Thanks & Regards,
Afshaan Shaikh
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.