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.

Grand total of all grand totals

tripdragon
in Calculation Engine (Define Fields)

Featured Replies

I have a grand total for each customers order for each record. But now I want to also have a Supreme grand total of all of the totals in every record add up into this supreme total. is this possible ? Does it involve the summary parts ? I can not make heads or tails of the summary parts and if anything that they do.

Assuming you are using sub-summaries to summarize your other totals, put the summary Total field on a Grand Summary part too.

  • Author

Ender said:

Assuming you are using sub-summaries to summarize your other totals, put the summary Total field on a Grand Summary part too.

Like I said I am not to intouch with how or what a summary part does. But I am learning ... Here is a file , the grand total I tried to make the "all" compute the total order but it will not pull all of them

apo.zip

Change your "all" field to a Summary field (Total of Order Total). This summary field will then show a total for all records in the found set.

  • Author

SWEET! It was that simple,, Now I feel stupid happy! Thank you ^v^

Create an account or sign in to comment

https://fmforums.com/topic/22181-grand-total-of-all-grand-totals/
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.