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?