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

    Calculation Condition in KPI



      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?