02-14-2022 10:14 AM - last edited on 05-24-2023 12:29 PM by JackLacava
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.
Solved! Go to Solution.
02-14-2022 10:36 AM
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].
02-14-2022 10:36 AM
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].
02-15-2022 03:34 AM
Thanks!