A lot of the functions of Excel or SQL are available in Protractor's reporting, but there are some significant ones missing. Specifically, we need the ability to COUNTUNIQUE() or DISTINCT() or DISTINCTCOUNT() when writing formulas for ⨊ Summary.

I run into this allll the time.

I filter a report to only show me Service Packages in the Transmission & Clutch Category. One work order may have several service packages on it that relate (Remove Disassemble & Inspect Transmission, Rebuild Automatic Transmission Assembly, etc).

Many lines on that one Service Package report pertain to the same vehicle. If I try to use the ⨊ Summary for a column total, it counts EVERY entry, not every unique Work Order # or File As name. If I want to know my car count on transmission-department vehicles, or state-inspection vehicles, I can't get that from Protractor. I have to count it manually.

But one little function could change that...

Thinking that I needed a bigger brain to try, I checked w my ChatGPT avatar "Sparky," lol. Sparky talked a little smack on Protractor... but in a nice way. He recommended those functions I listed above as what was needed to solve my issue. Here's what Sparky had to say when I asked him to Define a formula for me: