3 Replies Latest reply on Nov 2, 2012 2:30 PM by Alex Kerin

    Can I format some data (specifically $) differently than others, when it's all on the same view?

    Mike B

      I've got a dashboard that shows a lot of different data on one screen.  Because it's market research data, some of it is meant as a %, while others are $ values.  All of the actual numbers are stored in "Data". 


      I've tried to use a calculated field on Data to do:


      IF (left([Banner],1) = "$") THEN ("$" + [Data]) ELSE [Data] END


      But that doesn't work since I can't turn a float into a string. 


      Any idea's / workarounds?