Current Financial Year in calculated expression

[helen_pip]

Hello

Could someone kindly help me write the current financial year for the following calculated dimension

I have Current_Quarter (By number) available

I have Run_Month (By Number) available

I have Month_Year field (Apr-2013) available

=

if(InYear( CWT_Monthly_desc_Report.desc_month_Year, Today(),0), date(CWT_Monthly_desc_Report.desc_month_Year

,'MMM YYYY'))

My financial year runs from Apr-Mar

Is this possible with the above fields?

Kind Regards

Helen

[tresesco]

you can try this:

=Year(Month_Year) + If(Run_Month>=4, 1, 0)

[helen_pip]

Hello

Thank you for this suggestion

This is great as it gives me a bar for 2012,2013 and 2014

However what I wanted to achieve was the months for current FY  I.e.  April 2013, May 2013, June 2013 etc

Could you kidnly help me achive this too?

Kind Regards

Helen

[tresesco]

Your requirement is not very clear to me, can you please explain a bit like 'i have AAA and i want the output against that is BBB' ?