Share
Report
3Hi:
I have a data list called 'bids' that shows by vendor lists, which vendors have submitted or not by project/opportunities. The list, vendor names and projects are all in ascending order. I want to run a count of occurences of how many times in a row a vendor did not submit a proposal for any given vendor list. There could be many projects for a given list, all in ascending order. When a vendor submits, it should be marked back to count 0. The first time they miss, the count goes to 1 and so on until the next time they submit, the count goes back to 0.
This seems like a fairly complex list.accumulate type of function and I cannot wrap my head around it.
Any help would be greatly appreciated.
Categories:
I have the same question (0)
All responses (
Answers (
