Help required in evaluating count () in the below expression

[sandeepprasad_j]

Hi Experts ,

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.

[kaushiknsolanki · Accepted solution]

Hi,

     Try this expression.

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

Regards,

Kaushik Solanki