Hi

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:

```
select 'dbr.calc','CSqFt','[OTend]>0?(([OTend]+[SWide])/[Size]):0';
```

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.

Cheers

Jake