Expand my Community achievements bar.

Aggregator in a Calculated Column

Avatar

Level 2

I have an issue report and am trying to calculate a percentage for the total.. in this case 198,464 / 1111266 (these numbers are pulling as an $ value aggregation in a grouping.. I want to do the same thing with a percentage. I just want the actual calculation which in this case is 198,464/1,111,266 

Anyone have any ideas?? The answer I'm getting is 169%, but the answer I am trying to get is 18% (17.8 rounded up).

All the issue percentages are pulling correctly, but I can't get the aggregation to calculate. 

 

Code I'm using is: 

aggregator.displayformat=doubleAsPercentRounded
aggregator.function=SUM
aggregator.namekey=CP % Calculated
aggregator.valueexpression=ROUND(DIV({DE:Customer Profit},{DE:Net Sales})*100,2)
aggregator.valuefield=ROUND(DIV({DE:Customer Profit},{DE:Net Sales})*100,2)
aggregator.valueformat=customNumberAsPercentRoundedString
displayname=CP % Calc
textmode=true
valueexpression=ROUND(DIV({DE:Customer Profit},{DE:Net Sales})*100,2)
valueformat=customNumberAsPercentRoundedString

 

 

WhitneyHa_0-1700068959332.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies