I have a report where I need to count Document No.'s based on the No. Series value. This design works correctly for all situations except for where there is a correcting entry. In these cases, the CountUnique function returns both the duplicated record and the original record, which overstates the total. This occurs even though the formula is specifically written to only include the designated No. Series value.
In order for me to align the record counts, a second replicator is required under No. Series. I attempted to include an example, but I cannot upload excel files.
