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
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