dbr.calc issue

(3 posts) (2 voices)

Tags:

  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.