Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i created a dynamic table that is build based on the dimension/measure selected.
Everything is working except the margin which is easy to be calculated ( SALES - COST ) / SALES
=SUM((ExtendedUSD - ExtendedCostUSDADJ)/(ExtendedUSD))
as you can see below the margin is 1,119 which is wrong, should it be 0,50 (50%)
.
Check this? and enable the % from number format
=Num((SUM(ExtendedUSD) - Sum(ExtendedCostUSDADJ))/Sum(TOTAL ExtendedUSD),'#,##0%')
Try like this.
(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))
after this in chart properties number tab change to percentage for this expression
not working
Dear,
use the below expression:
=(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ)) / sum(ExtendedUSD)
=(Sum(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))
Check this? and enable the % from number format
=Num((SUM(ExtendedUSD) - Sum(ExtendedCostUSDADJ))/Sum(TOTAL ExtendedUSD),'#,##0%')
Don't give two sum in starting
(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))