Amount Format

[#1]

Hi All,

Greetings for the day.

I have one bar chart which represents the amount based on type and i have two text boxes to show data in dollars and percentage.

If i click on dollar button then values on bar should show like $ 100..If i click on Percentage button then it should show values on bars with percentage like 20 %..

For this i have created one expression and devided by variable values(based on selection either % or $).

But the corresponding $ and % values are not displaying in bar chart.

Could you please anybody take a look into this. I have attached sample QVW also.

Thanks,

Chiru

[sunny_talwar]

Try as attached

Best,

Sunny

[#3]

Hi Sunny,

Thanks for your Help.

All is fine but when we switch to % then axis is showing as 0.0 to 1.2 instead of showing 0 to 100.

Is there option to change this

Thanks,

Chiru

[sunny_talwar · Accepted solution]

Try attached:

[settu_periasamy]

Hi,

one more way, without using the if condition in expression,

like Num(Sum({<Type={'Target'}>}Amount)/$(vDlr),$(vDec))

PFA for reference..

[#6]

HI Sunny,

Thanks! This is exactly what i expected.

Thanks,

Chiru

[sunny_talwar]

Awesome

I am glad I was able to help.

Please mark the correct answer if you have got the answer you were expecting.

Best,

Sunny