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.