Alpha Video Training
Results 1 to 7 of 7

Thread: Using the expression builder

  1. #1
    Jim Dompier
    Guest

    Default 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. #2
    nick marodis
    Guest

    Default RE: Using the expression builder

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

    Nick

  3. #3
    Jim Dompier
    Guest

    Default 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. #4
    Jim Dompier
    Guest

    Default 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. #5
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,171

    Default 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. #6
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,171

    Default 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. #7
    Jim Dompier
    Guest

    Default 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

Similar Threads

  1. expression builder
    By John Burke in forum Alpha Five Version 6
    Replies: 1
    Last Post: 08-06-2004, 06:57 AM
  2. IF THEN ELSE in expression builder
    By Luc Verlee in forum Alpha Five Version 5
    Replies: 5
    Last Post: 02-05-2004, 03:39 AM
  3. Expression Builder
    By Bob Whitaker in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-16-2004, 02:15 AM
  4. Expression Builder
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-17-2003, 07:41 AM
  5. expression builder
    By eric bellingham in forum Alpha Five Version 4
    Replies: 1
    Last Post: 01-06-2001, 02:24 PM

Bookmarks

Posting Permissions

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