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.




      Thank you,