AnsweredAssumed Answered

I'm not bad at math, really (help!)

Question asked by techt on Nov 27, 2018
Latest reply on Nov 27, 2018 by techt

Call it what you will - wrapped around the axle, down the rabbit hole, eyeball deep - I've been stuck on a summary calculation and after a number of hours, I realized there are a lot of smart people here and I'm sure someone can point me in the right direction.

 

I have a list of items, grouped by type, and then counted if they've been delivered. What I'm trying to do is take the total count for each type, and divide it by the number that has been delivered, with the goal of ending up with a percentage of what's been delivered. This way we can look at a type and know where we stand as far as deliveries.

 

I've been chasing summaries, GetSummary, tried (and failed) ExecuteSQL (just not as strong in that as I was twenty years ago), and I'm unable to make this work. Now, just maybe, there isn't a way. In that case, the dent in my desk will indicate I should have asked sooner. I've attached a file so you can see where I am on this.

 

Thanks in advance!

Attachments

Outcomes