Skip to main content
N
NAS
November 21, 2024
Solved

Use POVPrior1 in XFGetCell?

  • November 21, 2024
  • 2 replies
  • 0 views

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!

Best answer by RobbSalzmann

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

R
RobbSalzmannAnswer
November 22, 2024

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")

N
NASAuthor
December 3, 2024

Thanks so much, Rob!  I tried it but it didn't work because I didn't use the quotation marks.  😂  Much appreciated!!

Terms & ConditionsAccessibility statement