I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average.
=AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No"))
I attempted to add a IFERROR formula but I am not sure where to add it or how to get it to work. If I add it at the beginning, it comes back as #INCORRECT ARGUMENT.
=IFERROR(AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No", "-")))
Am I putting the IFERROR in the wrong place or is there a better way to do this?
Any help with this would be greatly appreciated!!