8 Replies Latest reply on Feb 5, 2019 12:57 PM by Paul Wachtler

    Sum of a Calculated Field

    Heidi Ng

      Hi,

       

      I am new to Tableau and have been trying to figure out how to get the sum of  a column of calculated values. For example, the amount in local currency and exchange rates are from my data source. and The Investment in USD is basically a calculation by multiplying the amount and exchange rate. 

       

      When I tried to apply grand total, I only get a total of the "amount in local currency" column. The total for "Investment in USD" is blank.  I tried to use running_sum, but that's just a work around as I don't want just one value for the total. I also tried Window_sum but it didn't work.  please help!

       

      Currency
      Amount in Local Currency
      Exchange Rate
      Investment in USD
      USD20120
      EURO301.1434.2
      RMB1,0000.15150
      Grand Total1,050

       

      thanks,

      Heidi