6 Replies Latest reply on Sep 10, 2018 3:35 AM by Mahfooj Khan

    Different Number Formats in a Parameter

    Wong  Tze Xiang

      So guys,

      i have a map display that contains a parameter that can toggle between total amount in $ for each country and the number of transactions in each country. I have a calculated field to show size by displaying [Amount] if the parameter is at amount and the same for number of transactions. My problem is that my amount in $ is supposed to be represented in millions but when i use a calculated field, the default property is lost. How do i manually format the number from ones to millions and add the $ sign and the M just to amount and not both amount and number of transactions?