5 Replies Latest reply on Jul 19, 2018 9:01 PM by Zhouyi Zhang

    Concatenate a formated measure with text

    David Atwell

      I have a measure which I format to show in the millions. Shown here: $507M


      I would like to add text before this measure but when I do, it doesn't keep the formatting. (e.g. LM $507000000). The CF I use is: "LM" + " "+ STR([Last Year]), but i guess turning it into a string messes it up.


      The only way I know how to concatenate is by turning the Measure into a string, but this does't have the formatting I require.


      My desired result is: LM $507M


      What should my Calculated Field be?