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