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.