2 Replies Latest reply: Aug 8, 2014 6:18 AM by Karl Hart RSS

    Show result based on condition (not based on selection)

    Karl Hart

      I'm trying to have a text box that shows the description of a specified code

       

      I want to write something along the lines of

       

      =[PI Description] where [PI Code] = 'GK300'

       

      This will always show the Description of the Code GK300.

       

      What I dont want to do (but it works) is

       

      =If([PI Code]='GK300', [PI Description])

       

      as this will only show the description if GK300 is selected.

       

      I hope this makes sense. Any ideas?