Convert text to numeric value

[Natella]

Hello...


Is it possible to convert text in a text box on the report into numeric value so I could add them and see total on the report?
Thank you.

[June7]

Yes.

Are these textboxes bound to text type field? Is the data alpha or numeric or mixed? Show example of data and desired output.

[Natella]

Yes, it textboxes bound to text type.
I have a report that already has a field with total on the report footer. I need to add two numbers to this total from another report. I added textboxes and parameter values [Enter A. Expenses]. So, when I open the report I have to enter these two numbers. Maybe there is another way to add them?
Thank you for your help.

[June7]

I've never seen a requirement to pull values into report from another report.

I never use parameter input popups. Nearly impossible to validate the input.

Instead, use a form to input the values then open report. Report references the form controls.

Another alternative might be a domain aggregate function (DSum, DAvg, DCount, etc) expression in textbox.

[Natella]

Thank you. I'll think about other options.