Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Gopi_E
Creator II
Creator II

if two dates having 0 values then take that record other wise don't take that record

Hi All,

I have a data like bellow

Annotation.png

here i have to get if two dates or more having '0' Total Wait values then take that record otherwise don't take that record, please give any idea 

Here for example 100004 record having  '0' Total Weight for two Collection_Count with different dates so this record i want.

5 Replies
yoganantha321
Creator II
Creator II

Can you share sample data

Image was not clear understanable

Gopi_E
Creator II
Creator II
Author

Here I sent data

I want customer id who are having 0 total weight among all dates.Annotation.png

 

 

Gopi_E
Creator II
Creator II
Author

Here I have sent data please look on this

anushree1
Specialist II
Specialist II

please check the attached

anushree1
Specialist II
Specialist II

please check the attached