topic Best practice for number format on divide by 1000 in App Development

Best practice for number format on divide by 1000

paulyeo11 — Tue, 14 Jun 2016 23:14:57 GMT

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

Re: Best practice for number format on divide by 1000

vikasmahajan — Wed, 15 Jun 2016 06:02:20 GMT

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

Re: Best practice for number format on divide by 1000

paulyeo11 — Wed, 15 Jun 2016 06:22:54 GMT

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