round up thousand indicator when click on a button?

[oliviatww]

Hi there,

Wondering is that possible to round up number from 46000 to 50000 or 53000 to 50000 when user click on a button?

Any help is appreciated. THANKS

[ecolomer]

Yes it is possible with the function ROUND or CEIL par example:

[oliviatww]

Thanks for your reply Enrique.

Actually what I want is to allow user to click on the button, then round up all the numbers in my application including those one under expression or variables etc.

[#4]

You can bring the field values into  a listbox and set a conditional expression like below with a variable change.

=round(FieldName/10000)*10000 (In listbox expression)

Set the variable to button click event, so when the button is clicked, the variable changes to make the expression run and the list box values changes to is its round of values.

Hope it helps!!

Kiru

[oliviatww]

Thanks for your reply too Kiruthi.

Actually I'm not using fields but instead expression. I have got more than one expression so if I got 100 then it going to takes lots of time.

[#6]

Could you post a sample example??

[oliviatww]

Hi Kuruthi,

Thanks for your reply. I got that work already. Thanks a lot.