Alpha Video Training
Results 1 to 3 of 3

Thread: Need help with calculation

  1. #1
    Wanda Friesen
    Guest

    Default Need help with calculation

    Good morning,

    I want to write an expression for a report that states:
    If GPASCORE (a numeric field) is not blank, then print TESTDATE (a date field), otherwise print nothing.

    I've tried several different ways and am close, but no cigar! I think this is real close to being correct:

    IF(ISNOTBLANK(CHR(GPA_SCORE)),("TESTDATE"),"")

    Will someone please tell me what's wrong (and how to make it right)?

    Thank you!
    Wanda

  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: Need help with calculation

    Try:


    IF(ISNOTBLANK("GPASCORE"),DTOC(TESTDATE),"")

  3. #3
    Wanda Friesen
    Guest

    Default RE: Need help with calculation

    You be the man! It works beautifully. Thanks!
    Wanda

Similar Threads

  1. Age Calculation
    By mgorom in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-01-2004, 07:01 AM
  2. Age Calculation
    By Paul Reese in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-30-2003, 10:46 AM
  3. Age Calculation
    By Brett Heintzman in forum Alpha Five Version 4
    Replies: 6
    Last Post: 01-27-2003, 05:57 PM
  4. Calculation Help
    By Bill Griffin in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-20-2001, 10:16 AM
  5. If/then calculation in a set
    By Wanda Friesen in forum Alpha Five Versions 2 and 3
    Replies: 0
    Last Post: 06-01-2000, 11:20 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
  •