Calculation Condition in KPI

[#1]

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.

[brunobertels]

hi

May be this

Count({$<CA/TA%={">0.5"}>}Entity)

or this :

if(CA/TA%>'0.5',count(Entity))

[aarkay29]

Try this:

Sum({$<[CA/TA%]={">=0.2"}>}[CA/TA%])

[rupamjyotidas]

Count({$<[CA/TA%]={">=0.5"}>}Entity)

[#5]

Thank you. I tried Count({$<[CA/TA%]={">=0.5"}>}Entity) and it works.

[#6]

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.

[sunny_talwar]

I guess this thread is regarding set analysis, and the best place to start would be this

A Primer on Set Analysis

and then moving to some advanced stuff here:

Set Analysis: syntaxes, examples

[rupamjyotidas]

Please close the discussion