3 Replies Latest reply on Feb 11, 2015 7:35 AM by Alasdair

    Case Calculation



      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