5 Replies Latest reply on Oct 7, 2016 12:24 PM by David Li

    How do i change the format of a calculated field to currency?

    Rushita Shah

      Hi,

       

      I have a calculated field using case statement and I need to display the result as currency.

      case attr([Span]) when '2015Q3-2016Q2' then '$'+ str(round([Unadjusted sales])) else '' end

       

      I converted the field to a dimension to show in the table and was able to add in the $ sign in the formula. I need help getting the thousand comma separater. How can I do that?

       

      Current result:

      $82456

       

      Desired:

      $82,456

       

      Thanks

       

      Rushi