How to create a Button on dashboard for billions millions.

[#1]

Hi,

I've a sales table with total sales column contains more than 8 digit numbers.

User wants to have a simple Buttons for converting into billions millions.

Can anyone help me on this?

[suresh_rawat]

Hi Muarli,

With the use of variable you can do this.

Please go through the attached qvw, it will solve your problem.

In this QVW i have creat a vVar Variable and use it.

Regards

Suresh Rawat

[tresesco]

See the attached sample qvw.

[Anonymous · Accepted solution]

Hey,

PFA, TO give you basic idea..You can play as you like.

Hope this helps

BR,

Chinna

[#5]

How to add symbols at the end of the amount ex:- M or B

[#6]

How to add symbols at the end of the amount ex:- M or B

[#7]

Hi,

How to apply color to buttons.

For Ex:-

1. If I select Million, then Million button should be Green remaining buttons should be Gray color.

2. If I select Bullion, then Bullion button should be Green remaining buttons should be Gray color.

3. If I select Actual, then All buttons should be should be Gray color.

Help me ??

[#8]

create 3 buttons

Million, billion,actual

give action for that   and in layout tab write condition like if(getfieldselections(millon)>1,1,0) ...  like