2 Replies Latest reply: Dec 9, 2015 2:44 PM by Frank Cecconi RSS

    Calculation Help

    Frank Cecconi

      I am working in Sense and my calculation totals in my pivot table are wrong.  However when I select the currency code, then the totals are showing the correct value.

      DimensionsMeasures
      Aerospace161
        EUR25
        GBP10
        JPY30
        USD15

       

      The calculation for the measure is (it is a master measure):

      ((Sum([Amount in doc. curr.])* avg({<PYTD_Flag={1}>}[Actual Rate]))*-1)/1000

       

      The individuals values are correct, but the sub total (for Aerospace) is not.

       

      thanks

      Frank