Adding Summed Fields

[f0rg3tfu1]

Hello,

I have a quick question:

CR 10

I have done a simple sum of three straight colums out of the database. I would like to add these summed fields together to come up with a grand total.

I cant use a formula because it keeps returning "Must be a boolean".

Any ideas?

Col 1 Col 2 Col 3
Detail Detail Detail

Total1 Total2 Total3 GrandTot = (tot1 + tot2 + tot3)

 

[lbass]

Where are you creating this formula? You should be creating the formula in the formula editor (field explorer->formula fields->new). The formula should look like:

sum({table.col1}) + sum({table.col2}) + sum({table.col3})

This assumes that these are simple summaries that you have inserted on the detail fields. If you are using variables to create the column sums, then please provide the formulas you are using.

-LB

 

[mbarron]

You didn't post the formula that gives you this error... It almost sounds like you're trying to get a grand total using the Select expert instead of a formula field.

A formula such as the following would give you a grand total of the grand totals:

sum({field1})+sum({field2})+sum({field3})

Mike