Hello,
Just some background in case it is relevant:
In addition to the main financial statements, we have derivative reports. Ex. Income statement lists 5 expense lines, but the derivative reports lists every account that makes up the expense lines. It's an expanded, detailed listing of the income statement.
Now for the issue:
On this detailed listing, the formula to add a column of values is not working. It is adding irrelevant cells and producing a result of "cycle". I will go in and correct the formula and hit save. Here's the quirk: if I change a reporting date, or exit and re-load the report, the formula reverts to the original and does not seem to acknowledge that I made the correction! So I have to do this over again, and again... etc. Time-consuming to say the least.
There are other issues similar to above, ex. I will delete a superfluous line item on this detailed report and it will re-appear if I change dates or exit. Again, I am saving every time.
Any explanation or help would be most appreciated.
JC