6 Replies Latest reply on Nov 8, 2016 8:49 PM by Mahfooj Khan

    Number Formatting based on parameter

    keerthana kumar

      I have parameter to select Sales Amount or sales Quantity.

       

      i created a calculated field as below

      case [parameter]

      when 'Amount' then [sales_amt]

      when 'Quantity' then [sales_qty]

      end

       

      I wanted to show sales amount with one decimal point and units in thousands(K)

      Sales Quantity without decimal points and units in thousands(K)

       

      since it is based on one calculated field im finding it difficult.