6 Replies Latest reply: Nov 14, 2017 5:30 AM by pradosh thakur RSS

    Selecting blank fields in set analysis

    Sofia Vaz

      Hello everyone!

       

      In my script I have several orders. Each order must have an assigned planner-field name: InternalServPplanNome

      Sometimes it happens that there are orders without assigned planner.

       

      In one of the KPIs I'm looking at, I need to select some orders according to the planners, including those that have no planner assigned. How can I identify a blank field in set analysis?

       

      Right now I have something like this, but it's not working ...

       

      Count({<InternalServPplanNome={'MANUEL','JOAO',''}>}InternalServReadyLateDisp)/Count(InternalServReadyLateDisp)

       

      Any help would be appreciated.

      Thank you!