Fianancial Report Help

[hahsia]

Hi,

I'm developing my customer BS and P&L but cant seem to figure out how to do this.

My customer wants to see the month & year of the last & current period.

Let say the current period is April so instead of displaying current period she would like to see April 2006
and likewise the Last Period should display March 2006.
My formula is as follows:-
CHOOSE((MONTH(FRFISCAL("start",,FR("period"))-1)),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC") & " " & FR("YEAR")

At design mode the code shows correctly as in MMM-YYYY but when i run d report it shows #VALUE!.

Could somebody please help?
Thanks.

 

[ettienne]

=FR("End") gives you the period end date for the year and period you selected.
=TEXT(FR("End"),"MMM YYYY") gives you the month and year for the period end date, so the end of April will display as APR 2006.
=DATE(2006,6,0) will give you 05/31/2006.

Now combine all the above:
=TEXT(DATE(Year(FR("End")),Month(FR("End")),0),"MMM YYYY")

This will give you MAR 2006 if your period end is April 2006.

There are many different ways to get the same result...

 

[hahsia]

Thanx