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



      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: