4 Replies Latest reply on Mar 7, 2018 2:16 PM by Jonathan Hodge

    Formatting Different Param Values

    Jonathan Hodge

      Howdy All!

       

      I have a problem where my param will either show a currency or a quantity value.

      I need to add a '$' when appropriate and was hoping to not have to utilize string conversions.

      This article was helpful but I am hoping that since version 8 something useful has come out to help?

      Number Formatting with Comma Separator inside Parameter Calculation

       

      Currently my calculation looks like the following (using superstore data):

       

      IF [$ or Qty] = '$'

      THEN "$"+ STR(SUM([Sales]/[Currency Scale]))

      ELSEIF [$ or Qty] = 'Qty'

      THEN STR(SUM([Quantity]))

      ELSE STR(0)

      END

       

      And the following looks like:

      Is there a better way to accomplish this? I have Tableau 10.5 but attached is 10.3