Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Can I do this….
Released is a date
Annuity EQ is a number
Premium is a 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
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.
else do that
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.
You must be logged in to reply to this topic.
Log in / Register