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

    Sum of a Calculated Field

    Heidi Ng



      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!


      Amount in Local Currency
      Exchange Rate
      Investment in USD
      Grand Total1,050