Can I do this….

[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.
Or
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

[Brendan]

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.

Thanks,

Brendan

[Author]

Posts