Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can we show only 3 digits out of million

Hi,

How can we have only 900 in place of 90000000 in value on data points. Please help, I don't want to divide value with million.

Regards,

Navdeep

17 Replies
Anonymous
Not applicable
Author

Navdeep,

Define a variable: Ctrl+Alt+V->add->VariableName(Say VLakh)=100000

Then in your expression try:   YourExpression/VLakh

Hope this will help

Not applicable
Author

Yes, but then send to excel will give that divided value.

Anonymous
Not applicable
Author

True, but nothing can be done here. Even if you are defining symbol, you would get same.

For that, you can show a flag in chart header(like All values are in Lakhs)

evgheni_tirulni
Partner - Contributor II
Partner - Contributor II

Hello

I don't know if this stil an issue but I would try  using double() where in text part  I would show what I need to show and in numerical part what I need to have.

hope it helps!

Not applicable
Author

Hi, maybe so

sum.JPG

Not applicable
Author

Ok Yes, that flag is already there 🙂

sasikanth
Master
Master

hi,,

Delete the chart and create again ,

Not applicable
Author

Hi,

Can you share your qvw.

Regards,

Navdeep