Formula invalid - whileprintingrecords

[craig73]

I have a large number of this type of formulas. Summing quarterly and annual values like a spreadsheet.
When an "intermediate" formula is changed, a formula that depended on its setting, now also fails.
Example
numbervar q1 = sep + oct + nov
numbervar Yr = Q1 + ----

if the q1 calculation is changed then the Yr calculation is not correct

Why

 

[Ngolem]

Show the complete formulas .... not snippets

How does this relate to "WhilePrintingRecords" ??

If these are formulas that use summary functions then yes..."WhilePrintingRecords" cannot be used.

You don't show the positioning of your formulas...this is also critical...if both MUST be in the same section then you must use EvaluateAfter() function though I don't think this can be used with summary functions either. Placing the formulas in separate subsections in the order in which they must be calculated will solve the problem too.

BUT ALL THIS IS guessing on my part. Lay out your problem properly for a good answer...read my tagline.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!