Forum Discussion
Solved
Use POVPrior1 in XFGetCell?
Hi, I am using an XFGetCell Formula which references the POV for Time. I would like to use a formula to pull in the period prior to the POV in the same worksheet and keep it dynamic based on the POV. Any suggestions?
If it's not possible to do in the formula, I will need to create a UD8 to return the prior period time. Does anyone have a ready-made formula for this? I would greatly appreciate it!
Thanks!
Thanks!
Hi Nas,
To use a substitution variable in the XFGetCell, omit the pipes | and it should work:
Not this: "|POVPrior1|"
This: "POVPrior1"
example:
=XFGetCell(TRUE,"models_budfcst","total_models_inc","total_models_inc","Local","Forecast","POVPrior1","ytd","net_income","EndBal","Top","Top","total_country","total_accountSalesRep","Total_Customer","total_product","none","none","none","none")
2 Replies
Hi Nas,
To use a substitution variable in the XFGetCell, omit the pipes | and it should work:
Not this: "|POVPrior1|"
This: "POVPrior1"
example:
=XFGetCell(TRUE,"models_budfcst","total_models_inc","total_models_inc","Local","Forecast","POVPrior1","ytd","net_income","EndBal","Top","Top","total_country","total_accountSalesRep","Total_Customer","total_product","none","none","none","none")Thanks so much, Rob! I tried it but it didn't work because I didn't use the quotation marks. 😂 Much appreciated!!
