Is there a way to use functions as parameters in XFGetCell?

[LindaJ]

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. 

[ChrisLoran · Accepted solution]

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].

[LindaJ]

Thanks!