Skip to Content
0
Former Member
Mar 20, 2008 at 06:10 PM

Use of FISCAL_YEAR macro function

21 Views

I am trying to use the FISCAL_YEAR function in a macro (4.1 system) in order to determine the fiscal year for a bucket. My macro looks like below:

-Action Box-

LAYOUTVARIABLE_SET( 'YEAR' ;

FISCAL_YEAR(

BUCKET_EDATE(

ROW: KF XYZ (From column 1 with datasource column attributes)

) ; 'LT' ) )

**where 'LT' is the FYV and XYZ is the Key Figure

If I remove the FYV and switch

FISCAL_YEAR(

to

YEAR(

it returns the year in the data view.

Am I missing something?

Sean Mawhorter