Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my detail/fact records, I have a mapping for FiscalYr, and FiscalMonth based on the invoice date (our FY is 11/1 to Oct31)
My question is how do I do this to get the current fiscal month in the current fiscal year. I cannot simply say vCurFisMo=max(FisMo) or it will be 12 every time.
I would like in my script to say something like this: LET vCurFisMo=max(FiscalMonth) WHERE FiscalYear=vCurFisYr
So I do set analysis on vCurFisYr and vCurFisMo for my MTD and YTD calcs
how about a max with an IF() to filter down the FiscalMonths ?
max ( if( FiscalYear=vCurFisYr,FiscalMonth) )
how about a max with an IF() to filter down the FiscalMonths ?
max ( if( FiscalYear=vCurFisYr,FiscalMonth) )
Hi,
Use following
vCurFisYr = max(FiscalYear);
vCurFisMo = max({<FiscalYear = {"$(vCurFisYr)"}>}FiscalMonth);
Both of these equations worked but I was unable to get them to work within my script.
Let vCurFisYr=max(FisYr);
Let vCurFisMo=max ( if( FisYr=vCurFisYr,FisMo) ) ;
How I did get it to work though is by setting a Trigger on my Document Properties
So I wanted to take it a step further but am just getting a - returned. Each FisMo has a MonthName so I thought I could apply the same logic, but it is not working
try using a 'set' rather than a 'let' when defining the variables in the script.
Then use $() expansion when you invoke the variable in the UI.