ToddBeach

Sub Summary calculation problem

Discussion created by ToddBeach on Jun 22, 2018
Latest reply on Jun 26, 2018 by ToddBeach

Hi, I'm having a problem with a sub summary calculation that I though should be pretty straight forward but apparently not. I have found set of records sorted by a field named L# (our job number). Each L# may have multiple records but the list generated shows one instance of each, exactly as planned. One of the fields named # Plates, a calculation, represents the number of colors per job. I'm trying to get a grand total of colors that does not include the multiple records, only the one instance of each L# that I can see. Dropping a copy of # Plates in the Grand Summary gives me a count of the entire found set.

Outcomes