Alpha Video Training
Results 1 to 3 of 3

Thread: Reports -Calculated Expression Help

  1. #1
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,746

    Default Reports -Calculated Expression Help

    Ashampoo_Snap_Wednesday, May 22, 2019_15h55m32s_014_.png

    Creating a report similar to the pic above. Getting the Total Payments is easy: Total(Amount)

    What is the expression to get the total ONLY for cash, check, etc. payments? I've tried a number of things and have spent too much time on this detail.
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,560

    Default Re: Reports -Calculated Expression Help

    4 calculated fields like:
    cash=if(type="cash",amount,0)

    .....
    1 if cash
    2 if check
    3 if cc
    4 if not 1,2,or 3

    total all of those individually
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,746

    Default Re: Reports -Calculated Expression Help

    Perfect. Thank you!
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

Similar Threads

  1. Help with Calculated Field Expression
    By HRSue in forum Application Server Version 11 - Web/Browser Applications
    Replies: 15
    Last Post: 01-24-2012, 03:43 PM
  2. calculated? expression? function?
    By Lanny Tonning in forum Alpha Four Versions 7 and 8
    Replies: 1
    Last Post: 11-06-2006, 11:50 PM
  3. Calculated expression problem
    By George Corder in forum Alpha Five Version 5
    Replies: 8
    Last Post: 08-28-2003, 01:41 AM
  4. Need help with calculated field expression
    By Charlain in forum Alpha Five Version 5
    Replies: 4
    Last Post: 12-02-2002, 05:12 PM
  5. Help with a calculated expression
    By rtobiassen in forum Alpha Five Version 4
    Replies: 3
    Last Post: 08-20-2001, 06:11 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
  •