Can I do this….

Viewing 1 reply thread
  • Author
  • September 23, 2019 at 1:02 PM #36842

    john cesta

    IFEMPTY([Released];([Premium]*[Percent])+[Expense];IFEMPTY([Released];[Annuity EQ];0))

    Released is a date
    Annuity EQ is a number
    Premium is a number
    Percent number

    I want to say

    if the released date isn’t set display what I’ll be paid.
    If the released date isn’t set show the annuity eq I’ll be paid

    I tried putting each ifempty on a single line.

    Both fields contain values

    September 23, 2019 at 9:40 PM #36847


    Well, the IFEMPTY() function is like this:

    IFEMPTY([Field]; then do this; else do that)

    Your else part doesn’t really make sense because it would only get called if [Field] was NOT empty. But you’re checking to see if it’s empty in the else do that part.

    Do you perhaps just want this?

    IFEMPTY([Released]; ([Premium] * [Percent]) + [Expense]; [Annuity EQ])

    You can’t have it both ways because either [Released] is empty, or it isn’t.



Viewing 1 reply thread

You must be logged in to reply to this topic.