Count month

[#1]

Hello all

     I want to count number of months in current financial year as well as in previous year (though its fixed number 12),how do i do that??

[amit_saini]

Rohit,

Follow this:

Count of month

Thanks,
AS

[#3]

Hi,

You can use 'set analysis' or 'If' condition to get the result.

Example: If Condition ;

For Current Year : Count(if(Year_col=Year(Today()),Month_col))

For PreviousYear : Count(if(Year_col=Year(Today())-1,Month_col))

Regards.

[SunilChauhan]

count( {<FinYear={">=$(=max(FinYear)-1)"}>} distinct Monthfield)  for if you want combined

else

For Current Year : Count({<FinYear={$(=Max(Finyear))}>} Monthfield)

For PreviousYear :Count({<FinYear={$(=Max(Finyear)-1)}>} Monthfield)

you can calculate financial Year

MonthName(yearfield,0,4)

hope this helps

[jagan · Accepted solution]

Hi Rohit,

Try like this

For Current Year :

Count({<MonthDimensionName=, YearDimensionName={$(=Max(YearDimensionName))}>} DISTINCT MonthDimensionName)

For PreviousYear :

Count({<MonthDimensionName=,YearDimensionName={$(=Max(YearDimensionName)-1)}>} DISTINCT MonthDimensionName)

Regards,

Jagan.

[#6]

Thank you jagan