Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but I'm not getting any output.
=AVG(COLLECT([Transit Days]:[Transit Days], Carrier:Carrier, "DM", Origin:Origin, "HKG"))
Help Article Resources
Check out the Formula Handbook template!