I have a SharePoint list that keeps track of late and incorrect reports submitted by vendors. Every time a report is late or incorrect, a user add an item to this list. I am using separtae clumnx for late and incorrect as a Yes/No data type. I created claculated columns to convert the Yes/No to zero and 1.
I have another list that stores the actual number of reports due every month by vendor. I am trying to claculate the late and inaccurate rates based on user inout from the first list.
I am looking for a way to increment the late and incorrect count in the second list from the user input from the first list.
