Alpha Video Training
Results 1 to 6 of 6

Thread: help with IF

  1. #1
    Member
    Real Name
    David L. Aery
    Join Date
    Dec 2004
    Location
    Missouri
    Posts
    332

    Default help with IF

    this is a field in my Field Rules
    here is my formula:
    Code:
    IF(Invice_Detail->Transfer = ".T.",INVICE_DETAIL->PRICE*1.1,PRICE)
    "Invice_Detail->Transfer" this is a logical field

    if it is True I want this formula:

    INVICE_DETAIL->PRICE*1.1

    If it False I want this field:

    PRICE

    What am I missing?
    Attached Images Attached Images
    Last edited by David; 04-18-2019 at 11:12 AM. Reason: CORRECTION
    David
    A5V12.3
    Win7, 64 bit
    Qbks 2018 Enterprise
    QODBC R/W

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,318

    Default Re: help with IF

    I could be wrong, but I think ".T." should be .T.

  3. #3
    Member
    Real Name
    David L. Aery
    Join Date
    Dec 2004
    Location
    Missouri
    Posts
    332

    Default Re: help with IF

    i tried that and still no go, thanks
    David
    A5V12.3
    Win7, 64 bit
    Qbks 2018 Enterprise
    QODBC R/W

  4. #4
    Member
    Real Name
    David L. Aery
    Join Date
    Dec 2004
    Location
    Missouri
    Posts
    332

    Default Re: help with IF

    Whoops, that did fix it.
    Thanks,!
    David
    A5V12.3
    Win7, 64 bit
    Qbks 2018 Enterprise
    QODBC R/W

  5. #5
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,318

    Default Re: help with IF

    Glad it worked. You had me confused for a few minutes.

  6. #6
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,318

    Default Re: help with IF

    As an afterthought, you could actually use :
    Code:
    IF(Invice_Detail->Transfer ,INVICE_DETAIL->PRICE*1.1,PRICE)

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
  •