Jump 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.

How can i make my 60,000 thinner?

Spanner_east
in Calculation Engine (Define Fields)

Featured Replies

I have a company master file with 100 companies.

Every company has 3 copies of the 200 CDs we produce as their stock.

I also have a sales file with sales details file attached via a portal.

I want to show the companies stock with the sales subtracted but am unable to think of how to show their consignment stock. Showing each company_cd number to show the results would equal over 60,000 records?

how can i slim this down?

Tough to say without knowing just what you're trying to do. Are you trying to get a feel for how well each CD is selling? Trying to analyze who you need to restock? I mean, yes, if you have 60,000 CDs, then viewing every one of them will give you 60,000 records. But think about why you want to show those records and what you hope to learn from looking at them.

Jerry

Create an account or sign in to comment

https://fmforums.com/topic/22887-how-can-i-make-my-60000-thinner/
Go to topic listing

Important Information

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

I accept

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.