4 Replies Latest reply: Dec 12, 2017 9:26 AM by Stephane GRIMAUD RSS

    Tricky calculations agregations

    Stephane GRIMAUD

      Hi all,

       

      I try to implement a complex statistic calculation (trust interval) but I fail on an agregation problem :

      2017-11-29_17h05_09.png

      Calculation of the (ns/n2)*((Es(1-Es))+(nsSE2(ES))) column should be done at Groupe réadmission level and should be able to be agregated on all others higher levels, like, here, Service or Département.

       

      Calculation at Groupe réadmission level is ok (in green) and can be automatically agregated but it's impossible to get the right sum at Service level. Result is always wrong (in red).

       

      Here is the formula of the (ns/n2)*((Es(1-Es))+(nsSE2(ES))) column :

      2017-11-29_17h11_48.png

      If I do what is the most logic for me : sum(aggr( <the_formula> ,[Groupe réadmission])) then result is different but still wrong :

      2017-11-29_17h15_42.png

      It's correct only if a single Service is selected :

      2017-11-29_17h16_49.png

      I don't understand. I probably miss something. If someone has an idea, I would be happy to get it.

       

      Many thanks in advance,

       

      Stéphane