Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, this is a very strange one we've encountered. We have a basic if statement, that for one specific field, for only 3 records (out of about 100k) it fails. So for example;
If([Product Class] = 'X', [Gender - 1],
If([Product Class] = 'Y', [Gender - 2], 'FALSE'))
For every case of Product Class = X, it returns Gender 1 field correctly. For 99% of Y Product Class, it correctly returns Gender 2 field. However, for 3 records with Product Class Y, it returns "FALSE." Where things get very odd, though, is if I change the formula to be any other field besides Gender 2, it returns the correct value for those 3 records.
So it resorts to FALSE, saying the second If Statement is false, specifically ONLY for the Gender - 2 field. Any other field, or if we hard-code it, it comes back as True and provides the correct value.
Can anyone think of a reason why this would be happening?
No I can't, besides the obvious answer that the contents of Gender2 are 'FALSE' for these records. Are you able to provide us with those three records along with a sample document replicating the problem?
You might try:
If(trim([Product Class]) = 'Y',
Or
If(index(([Product Class],'Y')>0,