Inconsistent Formula Footer value (7.0)

[FinalPrime]

Hello,
Why would a footer formula's value get a different answer depending on whether the detail line is hidden or not?

I have a formula field made up of running totals variables. An error occurs (wrong answer) if both the following two conditions are met.

1) the detail line is hidden and 2) The group footer line is the first one on the page.

Options 'Keep Group Together' is checked.

I've tried WhilePrinting, WhileReading in the formula, but this has no effect.

I'm stumped and need some help.

thanks

finalprime

 

[BobSuruncle]

Running Total fields are 2nd pass fields.
They're terrific to use when you've got Group Selection or you're using Top N because they calculate what's showing.
Running Totals can also only be used in Group Footers (or in Details, if you want to see them increment).
If you want to calc stuff that's not showing, you may need to revise the report and use formulas instead or RT fields.

HTH


Bob Suruncle

 

[lbass]

I see this is a repost--it would be better to stick with your original post. In that post I suggested using the running total expert instead of manual running totals using variables (although I'm not sure it was available in 7.0). Do you have the group header set to repeat on each page? With variables, you have to be careful that this doesn't cause a reset (this wouldn't occur using the expert). If you have a reset formula in the group header, you should use something like:

whileprintingrecords;
numbervar x;

if not inrepeatedgroupheader then x := 0;

The other thing you might check is whether you have a "stray" formula placed in the page header or page footer that is adding an extra increment to the variable. I'm assuming you are using a display formula in the group footer that doesn't increment and that you are not simply adding the same formula from the detail section into the group footer--which would add another increment.

-LB