getting error in calculating sum(EBITDA) in qliksense

[divyanshi]

Hi All,

I am calculating sum(EBITDA) for one customer A .

I have Target Revenue column which is 1st column and then the Target EBITDA% which is in 2nd column.

At backend, I convert sum(Target EBITDA%)/100 as Target EBITDA%

Now I calculate 3rd column which sum(Target Revenue) * sum(Target EBITDA%)

Now in the above table sum is coming out to be 5.99 but this is not the total of all individuals rows which has 1.00.

How I get the correct sum?

Kindly help.

[Aurelien_Martinez]

Hi,

In Data > YourMeasure, change Auto to Sum in Total function

Aurélien

[divyanshi]

Thanks Martinez .

This is working fine for Normal table and Pivot table But How to get in KPI ??

[Aurelien_Martinez · Accepted solution]

With the Aggr function :

Sum(

  Aggr(

    sum(Target Revenue) * sum(Target EBITDA%),

    YourDimension

  )

)

[kaanerisen]

Hi Divyanshi,

Try this:

sum(Target_rev * [Target EBITDA%])