|Problem with percentage calculations [message #1783160]
||Thu, 08 March 2018 15:40
| Stuart Anderson
Registered: March 2018
I am a newbie here so please be gentle with me ;-)
I have a report that groups by a complaint category. I have added an aggregation on the group to return the number of complaints in the category and also a total sum in the footer of the table. This all works ok.
I have attempted to add another aggregation of type PERCENTSUM using row["Agg1"] / row["Agg7"] * 100
Agg1 is the sum of my complaints grouped by category and Agg7 is the sum total of complaints, so the above logic would be 2 complaints in group / 1114 complaints * 100 should return 0.1795%.
The expression that I have used returns 100% for each group. I am highly likely to be doing something extremely simple wrong but at this stage I am tearing what little of my hair is left out.
Powered by FUDForum
. Page generated in 0.01920 seconds