Format numbers in textbox?

[Eldar]

I have a textbox with the following content: 
=Sum(LossOfDaysMen)/(Sum(LossOfDaysNotSet)+Sum(LossOfDaysMen)+Sum(LossOfDaysWomen))*100 + "%"

This is giving me numbers with way too many decimals, like '66.44295155..', i want to to have just 1 decimal. How can i do this within the textbox? I tried String.Format, but that does not work. Setting the format property on the entire textbox does not work either, due the '+ "%" at the end. 

I assume there's some function i can run but im unsure about what syntax works within the textbox.

Any ideas how to solve this?

[Dimitar]

Hi Eldar,

When you open the Edit Expression dialog to set the value of the TextBox, you should be able to see a Functions field from the fields on the left corner.

Expand that field, then navigate to the Math section, this should let you see only the Math functions that can be used with the textbox.

From there you can use the second variant of the Round function that lets you round the value(first argument) to the specified number of fractional digits(second argument).

I hope that I have been able to help, please let me know if you have any other questions.

Regards, Dimitar Progress Telerik

[Reem]

in my case these are the values I got from the database using query but I cannot add round because it's parameter values so I want to use edit expression to  be like this = Round( (Fields. [Offshore-HP ]),2) but it doesn't work for me I got this error 

 

 

[Dimitar]

Thank you for the provided screenshots.

The error message is indicating the Offshore-HP field may not actually be of a numeric type. The Round(number, digits) math function expects number values for both arguments. If the field is of type string, you may try to convert it to int or double with our Conversion Functions.

If you need further assistance, please attach the report alongside some sample data, preferably in CSV or JSON format, and I will investigate the problem locally.