2 Replies Latest reply: Jun 15, 2016 2:22 AM by PAUL YEO RSS

    Best practice for number format on divide by 1000

    PAUL YEO

      Hi All

       

      I am about to place all my expression in master key , and i am not sure what is the right way if i have expression :-

       

      sum(sales)

       

      Should i input as :-

       

      sum(sales)/1000

       

      Pro :-

       

      1. make the number not so many digit.

       

      Con :-

       

      1 user may not know the amount is divide by 1000

       

      Any advise ? As i try to let user pick the expression and just click on number format = money.. and don't need to select custom and change the number by remove the last 2 digit and insert K . which is trouble some.

       

      Paul