Best practice for number format on divide by 1000

[paulyeo11]

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

[vikasmahajan]

So Don't  use sum(sales)/1000 in load script, you can use sum(sales)/1000 in expression of chart so that you can have both values full as well as user can see 1000 divided value.

Hope you understand.

Vikas

[paulyeo11]

Hi Sir

I am not refer to load script , I refer to put my expression in QS AS MASTER KEY.

Any way thank you for your feedback.

Sent from my iPhone