# of months with positive returns

[odassier]

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

[Chanty4u]

try this

=count(if(PA_Active>0,PA_Active),PA_Active)

[agigliotti]

maybe this:

Sum( Aggr( if( PA_Active>0, Count(PA_Active), 0 ), [MonthStartDate.autoCalendar.YearMonth] ) )

[shraddha_g]

TRy

Count( {<PA_Active {">0"}>}PA_Active) - - -  For Posititve

Count( {<PA_Active {"<0"}>}PA_Active) - - -  For Negative

[odassier · Accepted solution]

Hi Chanty,

This almost worked.  Fiddled with it a bit and found that it worked like this:

=count(if(PA_Active<0,PA_Active))

Thanks for the help

[odassier]

Hi Shraddha,

thanks for this.  I tried it but it gave me an error message.  I'm going to use the simpler formula hinted at by Chanty above.

Cheers,

Olivier

[shraddha_g]

Yes I Missed '=' sign.

Count( {<PA_Active = {">0"}>}PA_Active) - - -  For Posititve

Count( {<PA_Active = {"<0"}>}PA_Active) - - -  For Negative

[Chanty4u]

good  it worked for you.