We are under construction!

You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.

Forum Discussion

NAS's avatar
NAS
New Contributor III
13 days ago

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!

Reports
  • RobbSalzmann's avatar
    RobbSalzmann
    13 days ago

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

  • NAS's avatar
    NAS
    New Contributor III
    21 hours ago

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

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    13 days ago

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