Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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.
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.
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
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.
Thank you jagan