7 Replies Latest reply: Sep 12, 2017 4:50 AM by Chanty 4u RSS

    # of months with positive returns

    Olivier d'Assier

      Hello all,

       

      I am trying to setup a KPI with the number of months in my history that had a positive result.

       

      The total number of months in the data set was easy: Count([MonthStartDate.autoCalendar.YearMonth]) which returned the correct number (203).

       

      Now I'd like to add two more KPIs.  One for the number of months with a positive return, one for the number of months with a negative return.

       

      I tried: if(PA_Active>0,Count(PA_Active)) but that did not work.  it returns a "-"

       

      Any ideas?

       

      Thanks for the help.

       

      Olivier