dchaley369

Finding, totaling, confusing me

Discussion created by dchaley369 on Jul 20, 2017
Latest reply on Jul 20, 2017 by mardikennedy

Part A. How would do you find the invoice with the greatest amount for every day of the year (many invoice for each day), sum the grand total them and average them by the number of days searched?

Part B. I need to continuously add to this found set and be able to sync the found set using another layouts range search and average them by the number of days in the range search.

 

Thanks for any HELP!

Outcomes