Anyone ever do a Weighted Average Payment Term saved search? If so, would like to hear from you. The calculations are easy, but difficult to set up in NS. Probably done better in Excel.

Can you elaborate on the calculations? I've done weighted averages before, but I can't think of a what you mean by payment terms weighted

Thanks. Here's an Excel file that should explain what I wan the SS to do: https://documentcloud.adobe.com/link/track?uri=urn%3Aaaid%3Ascds%3AUS%3A95ad5788-26e6-46a0-bf5b-550028a63133