Change number format

[#1]

Hi

I have chart which has by default % format which has to change to number format once I click on button.

Thanks

[sergio0592]

You can do like this.

-Create a text box and a variable FL_format. In properties Action/Action/Set variable with =if(FL_format=1,0,1).

-In your expression : =num(sum(Express1)/ sum(total Express1),if((FL_format=1),'# ##0,00%','# ##0,00'))

Is this what you're trying to achieve?

[Anil_Babu_Samineni]

You may need one variable with Set Value from expression Orient

[Lech_Miszkiewicz]

All above are correct!

the other option you have is to create one column with % and one column with numeric format and then use variable and button to conditionally hide/show columns

i like this option more then formatting numbers using num function as it slightly changes values behaviour when exporting table to excel

regards

Lech

[#5]

hi,

I have created drill down group in chart & used Sum(pop)/100 as expression.

When I click on chart for Country or State it should calculated Sum(pop)/100. but when I click on City it should show only Sum(pop). This is the actual problem.

[Anil_Babu_Samineni]

May be change your expression

If(GetFieldSelections(Country) >0 or GetFieldSelections(State) >0, Sum(pop)/100, Sum(pop))

Or

If(GetFieldSelections(Country) >0 or GetFieldSelections(State) >0, Sum(pop)/100, If(GetFieldSelection(City)>0,Sum(pop)))