Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
With the Aggr function :
Sum(
Aggr(
sum(Target Revenue) * sum(Target EBITDA%),
YourDimension
)
)
Hi,
In Data > YourMeasure, change Auto to Sum in Total function
Aurélien
Thanks Martinez .
This is working fine for Normal table and Pivot table But How to get in KPI ??
With the Aggr function :
Sum(
Aggr(
sum(Target Revenue) * sum(Target EBITDA%),
YourDimension
)
)
Hi Divyanshi,
Try this:
sum(Target_rev * [Target EBITDA%])