1 2 Previous Next 16 Replies Latest reply on Aug 4, 2016 3:22 AM by Kwan Pichyangkul

    Grand Total using calculated field with ATTR()

    Kwan Pichyangkul

      Hi All,

       

      I'm using a calculated field that multiply the value with its currency conversion rate. Using this calculation

      SUM([Sales])*ATTR([Currency (Test total)].[Rate])

       

      When using grand total, the total shows nothing. I want to see the sum of converted Sales and Target. I've tried multiple ways to solve this but can't seems to get it to work. Could you please help?

      grand total.PNG

       

      Attached is the sample workbook.

        1 2 Previous Next