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 WhitneyHa_0-1700068959332.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/66153i497ED59340DBBC7A/image-size/medium?v=v2&px=400)