3 Replies Latest reply: Apr 5, 2013 9:53 AM by Sandeep Prasad RSS

    Help Needed : Count function returning wrong result in Expressions tab of Sheet properties

    Sandeep Prasad

      Hi,

       

      Please find the following expression that have been used to calculate the no. of rows containing specific field values :

       

      count({<[From Task]={'PublishingHolding' , 'ReviewAndProofHolding' , 'EscalatedPDS'}>}[To Task]='Escalations')

       

      The expected output should be the number of rows where the field value in [From Task] column is 'PublishingHolding' or 'ReviewAndProofHolding' or 'EscalatedPDS' and the value in [To Task] column is 'Escalations'. Kindly let me know if the above expression is correct, suggest any changes if required.

       

      Thanks a Heap.