Case (Balance Ability = "Good"; "No"; Balance Ability = "Poor"; "Yes";Respiratory Function = "Good"; "No"; Respiratory Function="Poor"; "Yes" )
Balance Ability = "Good" or Respiratory Function = "Good" ; "No" ; "Yes"
... but just to verify ... are there any records which might not meet either good or poor here? I ask because, if both fields are empty, you will have an empty result in this calculation. But if either of the fields contains data, it will evaluate.
Case() or If() calculations will evaluate and stop when they hit the first true so, in this case, if either field contains "Good" then the answer will be "No." Otherwise the answer will be "Yes". On the other hand, if you want BOTH Balance Ability and Respiratory Function to be good before producting a 'No' answer then you must change the OR to AND so that both criteria are true before 'no' is returned. And everything else (except both fields empty) will return "Yes".
This information is really helpful.
The calculation can work as what I want
thanks a lot