# Thread: Using the expression builder

1. ## Using the expression builder

Hello,

I created a calculated field to place on my form and calculate several other textboxes dollar amounts for a total. I'm good until I get to the expression builder and then I'm lost. What Ive been doing is like what I would do in excel, =first_field + second_field + third_field

This doesnt work however. Could someone give me a crash course on the expression builder or point me to one?

Thanks

Jim

2. ## RE: Using the expression builder

Jim
This will work if you drop the = sign
=first_field + second_field + third_field

Nick

3. ## RE: Using the expression builder

Hi Nick,

Thanks, I think I tried this and I didn't think it worked but I'll take your word for it and give it a shot.

Thanks

Jim

4. ## RE: Using the expression builder

Hi Nick,

You know I tried this and it doesn't work. In the expression builder, I am double clicking on my fields I want to add up, which puts them in the expression window, then I click on the + and then double click on another field and so on to get the expression as you stated, but it doesn't work. Any ideas?

Thanks

Jim

5. ## RE: Using the expression builder

Jim,

Your process seems correct, so there may be another problem. Are all fields numeric? Seems obvious, but we all miss the obvious sometimes. Also, after you create the expression, click on the evaluate button. If there is an error in your expression, an error message will popup with some information which may be helpful. Since it appears that you are working with currency fields, it is also a good idea to use the round() function to be sure you get the correct result. Here is an example using variables.

dim dollar1 as n
dim dollar2 as n
dim dollar3 as n

dollar1 = 12.52
dollar2 = 10.00
dollar3 = 156.32

total_dollars = round(dollar1+dollar2+dollar3,2) ' or 178.84

If one of the variables, say dollar2, was a character field you will have to use the val() function to convert to a numeric value.

total_dollars = round(dollar1+val(dollar2)+dollar3,2)

Jerry

6. ## RE: Using the expression builder

Jim,

Just reread you original post. If you are getting the dollar amount from a text box like ui_get_number(), the value returned is a character field, so you will have to convert to numeric. Otherwise, my example would return 12.5210.00156.32 - not exactly what you want.

Jerry

7. ## RE: Using the expression builder

Thanks Jerry, I'll give this all a try tomorrow when I go see my friend.

My friend is in need of an Alpha 5 programmer to finish this project. He had me do what I could to save money and also so a programmer could sorta see what he wants. So if you are interested in contract work please email me at isleosft@lava.net

Thanks

Jim

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•