Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I would like to count the Cost Center which meets the following condition:
sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) /
sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1
I tried sth like this:
if(
(sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC )
/
sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1 , count({<CostElementFlagPur={1}, PPV_Type=>} distinct CostCenter))
However, it does work, since it counts the total Cost Center and does not take into account the condition mentioned above.
Any Idea?
Many Thanks!
Edi
Hi,
Try with :
count({<CostCenter={"=sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) /
sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1"}>} CostCenter)
Hi Gysbert,
Thanks but it does not work. It just give me as result 0
😕
Hi Sergio,
Thanks but it does not work. It just give me as result 0
😕