Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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