15 Replies Latest reply: Sep 10, 2012 7:10 AM by ioannis giakoumakis RSS

    How to obtain a partial total by dimension

      Hi all!

       

      Please find image attached:

       

      Mc = Count(total <DESTINAZIONE, MEZZO> MVCDE) * MZPRT // MVCDE and MZPRT are two db fields

      Tot Mc = sum(total <DESTINAZIONE> Mc)

       

      Why am I getting 0 values as result? I don't understand where I'm making mistake, the red values shown in figure are the result I would expect...

       

      Do you need to know more details about db structure?

       

      Thanks in advance.

      --

      Marco Pikiri