Help on circular reference with POST

AntoineHM
AntoineHM
edited January 2024 in Modeling

Hello,

Do you know if it's possible to force the formula POST like LAG with STRICT argument.

My use case to be able to POST value in the future for stock equation.

If I use LAG(value , Leadtime , STRICT) or POST(value, 2) the formula are ok

If I use POST(value, Leadtime), I have a circular reference.

So I try to help using ABS(Leadtime) or SIGN(Leadtime) x Leadtime but I have always the same issue.

Can you help me with this issue.

Thanks a lot

Tagged:

Answers

  • TristanS
    TristanS

    @AntoineHM this is an interesting one. Are you able to share how value and Leadtime is being calculated.

  • JMVasicek
    JMVasicek
    edited January 2024

    @AntoineHM Agreed with Tristan, it would be helpful to know the formulas for Leadtime and Value. My hunch is that you're running into some of the behavioral differences between LAG and POST, but knowing the formulas will help identify that.

  • Iain_Briggs
    Iain_Briggs

    I am also encountering issues with circular references and POST. It seems strange to me that you cannot specify STRICT for the POST function when you can for related functions like LAG and LEAD. I would be interested to know if the product team are aware and have any plans for this.

Categories