Counting based on a condition

[Zaga_69]

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

[Gysbert_Wassenaar]

Try this:
count({<CostElementFlagPur={1}, PPV_Type=,CostCenter={"=sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) / sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1"} >} distinct CostCenter)

[sergio0592]

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)

[Zaga_69]

Hi Gysbert,

Thanks but it does not work. It just give me as result 0 

😕

[Zaga_69]

Hi Sergio,

Thanks but it does not work. It just give me as result 0 

😕

[Gysbert_Wassenaar]

All the field names must be the exact case sensitive field names. If you then still get 0 then there are no CostCenter values that meet the condition you specified.