5 Replies Latest reply: Dec 20, 2017 9:43 AM by Shahbaz Khan Mohammed RSS

    Format Number in Thousands for Master Items

    Radu Panciuc

      Hi guys,

       

      I have created a Measure under Master Items which sums up the Sales (sum(Sales)).

       

      What I would like to do is to display these Sales in thousands whenever I want (in certain tables) without modifying the Master Item.

       

      Let's say that sum(Sales) = $1,200,000

      I would like to display in my table: $1,200K

       

      Can I do this by adjusting the format in the Table options without altering the Master Items Measure?

       

      I tried to use the Number formatting but I was not successful.

       

      Capture.PNG

       

      Thank you,

      Radu