Count of opportunities missed

Like (0) Share

Report

Posted on 14 May 2024 20:49:46 by gauthierje

Hi:

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.