1. 

   ajdjackson, Member

   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
2. 

   myDBR Team, Key Master

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

   Can you open a support ticket in support email with the report SQL output. This way we can see the context where the calculation is used.

   It would be great if there was an dbr.sum option that would give an average for a column.

   dbr.avg gives you the average for the column. Was there something else you were looking for?

   --
   myDBR Team
3. 

   ajdjackson, Member

   Sorted.

   I had left one of the columns out of the dbr.sum statement that is used in the dbr.calc statement.

   In my defense it was a hidden column :)

   Cheers

   Jake

Reply

You must log in to post.