If possible please post the .twbx file with the dummy data. I can surly help you on this. Original data not needed. This can be solved conceptually.
Have you tried using the IFNULL() statement? You could say something like...
IF ISNULL([A]) OR ISNULL([B]) OR ISNULL([C]) OR ISNULL([D]) OR ISNULL([E]) OR ISNULL([F]) OR ISNULL([G]) THEN 'Hide' ELSE 'Show' END
yeah but my A is a string (NAME) here, so AND and OR is not allowed.
what should I try now?
I don't quite understand what you mean--the IFNULL() statement should work regardless of whether it's a string or numeric field. Is the data null (missing), or does the field say "Null"?
some are null but not all
i also tried OR but the error is still that AND and OR doesnt work with strings
1 of 1 people found this helpful
I'm still not totally understanding--so I made up some dummy data based on your screenshot, leaving some fields blank and others not.
If the data is missing (null), then the formula works. If the data says "null" but is not missing, then the formula would need to be modified. Either way--I didn't have the problem you described with getting an error with the AND or OR. See the screenshot below...
ah sh** I forgot the IF before the isnull
THANK YOU SO MUCH!