Forum Discussion

LindaJ's avatar
LindaJ
New Contributor
3 years ago

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

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#M...
Excel Add In
  • ChrisLoran's avatar
    ChrisLoran
    3 years ago

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

ChrisLoran's avatar
ChrisLoran
Valued Contributor
3 years ago

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's avatar
    LindaJ
    New Contributor
    3 years ago

    Thanks!