How to get around circular reference with an average?

Olek P
Olek P
edited July 30 in Modeling
ss18.png
ss19.png

Hi all ,

I have been having trouble with this problem. I created a simplified example of the issue.

I have a daily module. First I must manually calculate the Average balance with the sum & average line item because I only want the average to be calculated with "Working Days" (not holidays and weekends). (I must select all time periods because my balance is across multiple years. )

Once I get the average I would like to add it to the ending balance. I can't do this because it is a circular reference.

I would like to avoid creating an action to avoid the circular reference.

Anyone know how to get around this? Thank you in advance

Answers

  • Olek P
    Olek P
    edited July 30

  • Stacey_Gibbens
    Stacey_Gibbens

    Hi Olek,

    I think you can get around this by creating an additional line item that is the previous end balance, and reference the new line item in beginning balance calculation (instead of making it part of the beginning balance calculation). At least, I seem to remember doing that at one time…

    Best wishes,
    Stacey

  • Olek P
    Olek P
    edited July 31

    Hi Stacey, thank you for trying but it didn't work unfortunately. The problem is the sum line item is selected for all time periods.

  • Olek P
    Olek P

    I just used an action to paste the value and break the circular reference

Categories