Skip to Content
0
Former Member
Dec 03, 2008 at 09:25 PM

Nested formula fields

26 Views

I am having trouble with a report that uses many formula fields. Each formula field works just fine on the detail and summary lines except: I would like to have a formula field that will total all the other fields on the same line, a bit like a spreadsheet (which is what I'm replacing with the report). In other words, the final field will be a total of all the fields to the left. Rather than having a 40 line formula that I would have to manage if any of the other fields changed formulas, I thought I would try the following:

formula = {@CO2} + {@Equipment} + {@hel_amt_due}

If I use just one of these formulas, the total matches. As soon as I try to actually add two or more together, I either get one of the formulas, zero, or something quite random. I assume that this formula is calculating before some or all of the other formulas, so I added Evaluateafter({@CO2}), etc. above this formula, but with the same results.

What am I missing?

Thanks in advance.