18 Replies Latest reply: May 10, 2017 10:58 AM by Sunny Talwar RSS

    % 3 dimensions

    Benjamin ROY

      Hello, I want to calculate the% of my turnover by product family on the total turnover.

      I have 3 dimensions : nomenclature 1 / nomenclature 2 / nomenclature 3

      - the% of the nomenclature number 1 s / total digit => OK

      - the% of the nomenclature number 2 s / total nomenclature 1 => NOT OK

      - the% of the nomenclature number 3 s / total nomenclature 2 => OK

      I do not understand why 2nd is not working. 

       

      Scripts used :

       

        If (dimensionality () = ('1'),

      Sum ([PV HT]) / sum (TOTAL [PV HT]),

      If (dimensionality () = ('2'),

      Sum ([PV HT]) / sum (TOTAL <[Nomenclature 1]> [PV HT]),

      If (dimensionality () = ('3'),

      Sum ([PV HT]) / sum (TOTAL <[Nomenclature 2]> [PV HT])

      )))) 

       

       

      Thank you for your help