4 Replies Latest reply on Oct 24, 2013 8:52 AM by Charles Hagin

    Showing Different Number Formatting Based on Parameter Selection

    Charles Hagin

      I’m stumped and hope y'all can help me with this.  We have a dashboard that needs to alternate between showing units and dollars but
      can’t figure out how to get the dollar sign to show up for the dollars portion and not the units portion.

          

      We’re using a parameter to control which field is displayed via a calculated field (iif([UnitOrRetail]="Units", [NET_SLS_QTY],
      [NET_SLS_AMT]))

          

      We’ve tried:

       

      • Changing the default number format of the [NET_SLS_AMT] field to currency.
      • Casting the values as a string and tacking on a $ (ends up treating the value as a Dimension instead of a Measure)

       

      Any ideas?