Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this expression.
count({<[From Task]={'PublishingHolding' , 'ReviewAndProofHolding' , 'EscalatedPDS'},[To Task]={'Escalations'}>}1)
Regards,
Kaushik Solanki
Hi,
Try this expression.
count({<[From Task]={'PublishingHolding' , 'ReviewAndProofHolding' , 'EscalatedPDS'},[To Task]={'Escalations'}>}1)
Regards,
Kaushik Solanki