Account Schedule - Circular References

annie1234

Hi all,

May any expert can help how to sort out this issue, this is an error message popping up in the Account Schedule.

"Because of circular references, the program cannot calculate a formula.
The error occured when the program tried to calculate
Acc. Sched. Line: Row No.=PBT, Line No.=780000, Totaling=EBIT+71+72+73+74+75+76+77+78
Acc. Sched. Column: Column No.=1, Line No.=10000, Formula="

THX
Annie

ara3n

I suggest to set all the RowNo with a prefix of R

So that formular won't get confused. Also Make sure 71+72+73+74+75+76+77+78 do not reference themselves.

pmusu

Use a maximum of 3 totals.
Name it E.G. EBITA 71+72+73
EBITB 74+75+76
...

Hope it helps.

annie1234 wrote:

Hi all,

May any expert can help how to sort out this issue, this is an error message popping up in the Account Schedule.

"Because of circular references, the program cannot calculate a formula.
The error occured when the program tried to calculate
Acc. Sched. Line: Row No.=PBT, Line No.=780000, Totaling=EBIT+71+72+73+74+75+76+77+78
Acc. Sched. Column: Column No.=1, Line No.=10000, Formula="

THX
Annie