1 Reply Latest reply on Mar 29, 2011 10:06 AM by philmodjunk

    Calculation to compare a range of names in a calculated field to a Value list and return Values that...

    JoshHyman

      Title

      Calculation to compare a range of names in a calculated field to a Value list and return Values that are not included in the Calculated cell

      Post

      Hi Folks,

      I am, after some help with a calulation i wish to use.

      Basically I have a calcuation field SHOWS::ScubaNames that uses the Getfield("exapmle") to return a range of names from multiple fields I then seperate these by carriage returns.

      I then want to compare this field SHOWS::ScubaNames to a value list "Boat Scuba" and have another calculation field SHOWS::AvailableScuba show me what names are in the Value list that are not in the calulated field SHOWS::ScubaNames.

      I hope this makes sense Basically I want to compare a range of names in on field to a value list and return the difference.

      Can anyone point me in a direction to start??

      Many thanks in advance

      Josh