I've created a report which calculates a field.
This works great at row detail level but I can't get it to work at summary level.
This is what I'm using in the calc statement:
As I said this works at row detail level but at summary level it always results in zero.
If I add the column to the dbr.sum then I get a sum of the value - not what I require.
Any thoughts on why this isn't working? Probably the conditionality in the dbr.calc formula.
It would be great if there was an dbr.sum option that would give an average for a column.