Alpha Video Training
Results 1 to 2 of 2

Thread: Help on calculated filed

  1. #1
    Member Jerry Hartness's Avatar
    Real Name
    Jerry Hartness
    Join Date
    Apr 2000
    Location
    Knoxville, TN
    Posts
    427

    Default Help on calculated filed

    Ok, need a little help here, could not find by searching, but have a browse (child, see attached) that has a total at the bottom that shows the amount of all parts. This program keeps up with returned items with vendor. Also is a picture of the calculated field to get the total. If you will notice I have on the right side of the browse (each line) is a RTD field. Sometimes we don't get credit back at the same time for each part. What I want to do is if an item has been returned I will check the RTD field and want the total to either set to zero or if more than one item still outstanding I want that amount (the one checked) to be subtracted from the total. I have tried all sorts of "if this, then this, else this" using the logical field RTD and A5 won't accept any of my calculation. I know there are lots of ways to manipulate A5 to work, but would prefer a simple solution

    Thanks

    Jerry
    Attached Images Attached Images

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Help on calculated filed

    Total() was originally designed for reports and is not very flexible. You will likely wind up with a tablesum().

    I'm thinking

    tablesum("part","invoice = "+s_quote(invoice_number.value)+" .and. (.not. rtd)","p_amount")

    where invoice_number.value is the vendor invoice number object name on the form, and the value property of that.

    Complicated requirements don't often lend themselves to simple solutions.
    There can be only one.

Similar Threads

  1. How Can Change Enter Key instate of Tab Key to Go One Filed to Another Filed Grid-DLG
    By firozkhannoor in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 04-03-2013, 05:50 PM
  2. update filed value and redirect
    By richard2007 in forum Application Server Version 9 - Web/Browser Applications
    Replies: 6
    Last Post: 10-15-2009, 04:15 PM
  3. \ being stripped from filed
    By Atta in forum Application Server Version 9 - Web/Browser Applications
    Replies: 4
    Last Post: 01-08-2009, 12:37 AM
  4. Reaching a Max No in filed
    By John Burke in forum Alpha Five Version 5
    Replies: 3
    Last Post: 04-18-2005, 11:31 PM
  5. Filed Values into Veriables?
    By Keith Hubert in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-09-2003, 12:57 AM

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
  •