Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Identify missing products for forecasting

lizzie
in Calculation Engine (Define Fields)

Featured Replies

Greetings

Would love to hear suggestions as to how to solve the following problem:

Everybody prints to a networked printer. As such, it is imperative that we have stock of all consumables at any one time.

I thus created a subsummary report which identifies the unused consumables in stock. The next step is to identify those consumables that aren't in the subsummary report so as to flag those as "super urgent" stock to be ordered.

My mind is completely obsessed with combinatorics and I cannot see another way of identifying what consumables are missing from the subsum report.

I'm looking for a change in direction! Surely there is an easier way to identify the "missing parts"?

I have attached an exported version of my report thus far!

Any help or advice would be great! Haven't got stuck into FM for a while and I seem to keep hitting brick walls!

Phaser.fp7.zip

  • 2 weeks later...

Using GTRR(all) and Show Omitted, I believe the attached may work for you.

Phaser.zip

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.