IF SUM(PLAN) = 0 then 1
Something like that.
Yeah I forgot the else portion of that thank you
Tableau will return a Null if it tries to divide by zero - so ifnull(attr(calculation),1) will return a 1 but when you bring it to the viz tableau will aggregate it so you will need to take a Max(), Min() or Avg()
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.