Circular Reference Problem

6.15K viewsFormulas and Functions

Here are my two formulas:

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


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?



No problem. I found that looking at a few of the demo models was helpful, but I agree, the formula documentation does seem to be a bit sparse.

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