Is this a calculation field?
Are the summary fields and this calculation field all defined in the same table?
What records are in your current found set?
Are you trying to calculated a single result for all records in your current found set or use different subtotals based on different groups of records within your found set? (grand totals or sub summary layout part based subtotals?)
Yes, this is set as a calculation field.
The summary and fields being summarised are all on the same table.
The found set has other summaries based on these same fields, so I would expect it to work, bearing in mind the figures have been used elsewhere.
I'm looking to calculate a subtotal, not the grand total. There are several rows of data (created by the repeating sub summary per customer) and for each row, the IF statement should pick the higher of the previous two summary figures and place them in the column.
Strange thing is, if I reverse the logic operator from < to >, I get the result I was after, but the other calculation results disappear from the sub summary.
Im wondering if this might be due to the second summary field on occasion being empty - there's not always data to sum up.
Not sure if this would count as zero, null, isempty or whether indeed the script would need protecting for this occurance.
Sorted, I'm a numpty