dbr.calc not working in same report after using dbr.crosstab

(3 posts) (2 voices)
  1. akker, Member

    Hello!

    I have complex report, that has multiple tables in it. One of them uses dbr.calc and is something like this:

    select 'dbr.calc', 'percent', '[Total]/[Total.sum]*100';
    select 'dbr.calc', 'percent2', '[Bad]/[Bad.sum]*100';
    select
    DATE_FORMAT(a.paid_date,'%Y-%m') "Month"
    ,count(*) Total
    ,100*b.percent as 'Bad %'
    , null 'SG weight[percent]'
    , null 'Bad weight[percent2]'
    , round(count(*)*b.percent) as 'Bad'
    from ...
    ;

    if this tabel is placed as first table in report, everyhing works like a charm. But if I put it after table, that uses "dbr.crosstab" feature, the calculations fail and "percent" and "percent2" fields stay empty.

    Posted 5 years ago #
  2. myDBR Team, Key Master

    This has been fixed in the lastest build.

    --
    myDBR Team

    Posted 5 years ago #
  3. akker, Member

    yes, thank you. it was fixed really quickly.

    Posted 5 years ago #

Reply

You must log in to post.