Formula not working on report

[qlikviewaf]

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%)

.

[hari8088]

Try like this.

(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))

after this in chart properties number tab change to percentage for this expression

[qlikviewaf]

not working

[mdmukramali]

Dear,

use the below expression:

=(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ)) / sum(ExtendedUSD)

=(Sum(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))

[Anil_Babu_Samineni · Accepted solution]

Check this? and enable the % from number format

=Num((SUM(ExtendedUSD) - Sum(ExtendedCostUSDADJ))/Sum(TOTAL ExtendedUSD),'#,##0%')

[hari8088]

Don't give two sum in starting

(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))