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