The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Duplicate Items different Prices

posted Sep 21, 2020 9:43:09 PM

0 583 0

Working with a healthcare related database where items are used across several departments. I need to identify where the price charged is different from other departments. Ideally, I would be able to have a check box or notate them in some where where I could then filter/group.

Example:
Item Department Price
123 ER $50
123 Clinic $50
123 Radiology $100

How could I flag Item numbers there is at least 1 with a different price?

Hope this makes sense.

0 Replies 0