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#MonthPrior1([actual month]) instead of using some excel functionality to calculate 2022M1 and use that. 

 

 

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