Removing duplicate Material Requisitions (MR #) when counting

Hello, I am trying to count the number of requisitions (MR ‘s) per shop, minus duplicate MR's.

Duplicate material requests equal one transaction (i.e., "1234" listed multiple times in a column still only equals one transaction). The MR # applies to multiple parts, thus the need for multiple submissions but still only one transaction.

So, essentially, I need the number of transactions per shop, per year. I cannot seem to create a formula that does everything above.

Also, I do not want to hide the duplicate material req's on the grid. Any suggestions are appreciated. 😊

Kathy

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

Hi @Katkss, I would use the DISTINCT function for this, something like =COUNT(DISTINCT([MR #]:[MR 3])) would give you how many distinct values are in the MR # column. Hope this helps!

Paul Newcome

Your formula would be something along the lines of

=COUNT(DISTINCT({MR # Column}))

Katkss

Thank you so much. I will give Distinct a try. 😊

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.