7 Replies Latest reply: Mar 3, 2017 1:10 PM by Rupam Das RSS

    Calculation Condition in KPI

    Michelle Chiang

      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.