This content has been marked as final. Show 7 replies
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 "-"
Thanks for the help.