In the given formula the logic is currently:
In a given row if any of costelementforsupplier, vendor sum name, or summary name are NULL then return the summary name, else return the vendor sum name.
How would you like it to be different?
Thanks for your reply.
May be i dint explain it correctly. Basically i want to check for null in all three fields, and if and then if either is not null then select that field as my ans. In above, due to THEN and ELSE i can only choose 2 out of three options and thus if both are null and costelementfor supplier has value, that is not populated.
How do i check for all three?
1 of 1 people found this helpful
I'm still not totally sure what you are trying to do here... I *think* it might be something like:
IF NOT ISNULL([field1]) THEN
ELSEIF NOT ISNULL([field2]) THEN
ELSEIF NOT ISNULL([field3]) THEN
The ELSE NULL part is actually optional in Tableau, it imputes an "ELSE NULL" if there is no ELSE statement.
This can even be shortened to:
If this doesn't answer your question then please provide some sample data and a description of the output you are attempting to achieve. Mocking up several rows in MS Excel would be enough, I think. Please see Packaged workbooks and flows (and Tableau Public links): when, why, how for more info on why we ask for sample data & packaged flows.
this answers the question - i was having trouble with multiple IF and was not aware about NULL for ELSE .