Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a KPI counting entities with 50% or more current assets over total assets.
The sample data I have is as below:
Entity CA/TA%
A 0.1
B 0.2
C 0.3
D 0.7
E 0.8
The answer should be 2.
I selected "Entity" as my measure and tried to put a calculation condition but don't know how.
Anyone can help?
Thanks.
hi
May be this
Count({$<CA/TA%={">0.5"}>}Entity)
or this :
if(CA/TA%>'0.5',count(Entity))
Try this:
Sum({$<[CA/TA%]={">=0.2"}>}[CA/TA%])
Count({$<[CA/TA%]={">=0.5"}>}Entity)
Thank you. I tried Count({$<[CA/TA%]={">=0.5"}>}Entity) and it works.
BTW, I haven't learned any computer language except VBA for Excel.
If I want to gain some basic knowledge about this language, which one should I go to?
Thanks.
I guess this thread is regarding set analysis, and the best place to start would be this
and then moving to some advanced stuff here:
Please close the discussion