This formula ignores multiple AND's

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

 If(IsNull([Age]) and IsNull([Salary]) and IsNull([Expected OTE (Overall Total Earnings)]) ,0,1). If all of those fields are NULL then I expect 1.


The fields are ether numeric or Currency


Photo of stuaz

stuaz

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
 If(IsNull([Age]) and IsNull([Salary]) and IsNull([Expected OTE (Overall Total Earnings)]) ,1,0)


I think that you need to just flip the 0 and 1.  Be sure that those fields are set to not treat blank as zero.
Photo of stuaz

stuaz

  • 10 Points
Hi, yeah they are set to not treat blank as zero, but if populate one of the fields with data it changes it to a "1", where I would expect it be a 0 as the other fields are still blank.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Please explain in English words what you are looking to do and i can help you with the formula to do that.  or else give a couple of examples.
Photo of stuaz

stuaz

  • 10 Points
Hi, I have three fields. If ALL of these three fields are blank, then the formula should return the number zero. If only one of the fields is populated, it should still return zero. If ALL of the fields are populated then the formula should return the number 1.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
try this

 If(not IsNull([Age]) and not IsNull([Salary]) and not IsNull([Expected OTE (Overall Total Earnings)]) ,1,0)
Photo of stuaz

stuaz

  • 10 Points
Perfect Thanks,