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:
LAYOUTVARIABLE_SET( 'YEAR' ;
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
it returns the year in the data view.
Am I missing something?