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