4 Replies Latest reply: Mar 29, 2017 3:27 AM by nayan lalla RSS

    Text Box Expression - Change on Selection

    nayan lalla



      I have 3 text boxes with expressions:


      Total Text Box:

      =Count( DISTINCT(Call))


      Incidents Text Box:

      =Count({< [Call Type] = {'Incidents'}>} DISTINCT(Call))


      Requests Text Box:

      =Count({< [Call Type] = {'Requests'}>} DISTINCT(Call))


      Its a count of calls, where the first is Total, the 2nd is where the Call Type = Incidents and the last where Call Type is equal to Requests.


      How do I create an expression in the Incidents and Request text boxes, so that when I select "Incidents" under Call Type, the Request Text should display nothing.  Similarly, If I select "Requests" under Call Type, the Incidents Text box should display nothing.


      Please can you help.


      Kind regards