Circular Reference Problem

6.15K viewsFormulas and Functions
0

Here are my two formulas:

Gross Members End Bal:Month[THIS]= Beginning Bal Members:Month[THIS]+New Members:Month[THIS]

and

Beginning Bal Members:Month[THIS] = Gross Members End Bal:Month[LAST]

Both are throwing me error messages saying that the formulas are involved in one or more circular references. I could get rid of the Beginning Bal Members item altogether, except that I need it to calculate another item (churn). Any suggestions?

thanks!

0

I think you mean [PREV], rather than [LAST] in the second formula. Correcting that should remove the circular reference.

Cheers, Paul.

You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes