AnsweredAssumed Answered

Case Calculation

Question asked by Alasdair on Feb 11, 2015
Latest reply on Feb 11, 2015 by Alasdair


Case Calculation







I'm trying to solve a problem any help would be appreciated thanks.

I have three calculation fields with a "text" result.

Field 1 will contain the result either "Full" or "Empty" as will Field 2. I want field 3 to show "Empty" if both 1&2 are showing the result "Empty" Should either Field 1 or 2 show the result "Full" field 3 will Return "Full"

Should both fields be empty the default result will be "Empty"

I have tried various case calculations and can only get one field to calculate a result.

Thanks again.

Al McMonagle