Problem with percentage calculations [message #1783160] |
Thu, 08 March 2018 15:40 |
Stuart Anderson Messages: 3 Registered: March 2018 |
Junior Member |
|
|
Hi All,
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.06220 seconds