I want to stop the process only if excel rows have status as CANCELLED is >60%? Please help with the query for excel

Help Studio
,
1

image

2

Hi,

How about the following?

image

dt.AsEnumerable.Count(Function(r) r("Status").ToString="Canceled")/dt.Rows.Count>0.6

Regards,

2 Likes
3

Thank you so much for helping even on Saturday. :slight_smile:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.