Are you trying to just remove the nulls from the visualization so that blank spaces appear instead?
Try using this: IFNULL([Association],"") Create one of those for each Assocation and Option and all the nulls are gone.
No, I am not trying to get rid of the nulls. This is how the final result should look like (see below). I need to create a calculation that would account for the nulls based on my conditions. Once the "Association" calculation is ready to go, I will remove the Option 1-4 from the view and will end up with the "Association" column only.
I essentially want my calculation to grab one of the options that would be captured under "Association".
Let's say for line 1: if option 1 is null, if option 2 is null, if option 3 is null then take option 4 and place it under the "Association" Red SET.
For Lines that have option 1 available, I want the calculations to grab option1, for lines that don't have option 1, but have option 2, grab option 2 (even if they have option 3 or/and 4).
For lines that have option 3 (and don't have option 1 and 2), i want the calculation to return option 3 (even if option 4 is available.)
Does this make sense?