I have a report that I need to show a field where there may be more than one of the same only once. To give a better example the report has 2 items -
Invoice Number and Part - I have the report grouped so that it breaks after each invoice number and gives the number of items for each invoice. But there can be the same type of item for each invoice but only want it to show one time. I have tried using the Suppress if Duplicated option in formula Editor for this field but it does not work - still showing the duplicate items. Can someone please tell me how I can suppress duplicates.
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.