6 Replies Latest reply on Jul 17, 2012 1:57 AM by Vladimir Rybovalov

    Multipluing two dimensions with one measure

    Vladimir Rybovalov

      I have one dimesion which has  2 fields.

      for example 'Volume' and 'Price'

      and one measure for them AMT.

      I created 3 calc fields"

      1) Volume_measure :

      if [dimension]= "Volume" then [AMT]

      end

      2) Prices_measure:

      if [dimension]= "Price" then [AMT]

      end

      3) Volume*Price:

      sum ([Tranport_Volume])*sum([Transport_tarif])/[VAT]

       

      the problem is  - price is different for each month, so i get the correct numbers by months, but for the whole year it results in wrong numbers (it multiplies Total Volume*Total Price).

      any suggestions how to resolve this issue?