Is there a way to use functions as parameters in an XFGetCell formula?
I want to retrieve values for the previous month to compare to the actual month.
It would be nice to use something like T#MonthPrior1([actual month]) instead of using some excel functionality to calculate 2022M1 and use that.
You should be able to use WFPrior1 .. WFPrior2 .. WFPrior12 etc.. in the XFGetCell formula.
Like this:
=XFGetCell(TRUE, "MainCube", "Ent037", "", "Local", "Actual", "WFPrior1", "Periodic", "M614700", "None", "BeforeAdj", "None", "None", "None", "None", "Local_Inp", "None", "None", "None", "None")
(tested on v6.8.1)
This is assuming you are using the workflow time as a reference. For more custom specifications you can always use Excel formula to create a custom time string [but beware of varying data frequency by scenario].
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.