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.

Complex Date Summary Reports

lance123
in Relationships

Featured Replies

Hi To All,

Hoping someone has a smarter way of doing a multiple date range summary report. I have two fields which specify a date range. I then have fields which divide this range into days months or weeks depending on the user selection. I then use multiple relationships to grab and summarise data between the multiple date ranges. Ie 12 months = 12 ranges. It just all starts to get very laborious when trying to do 52 weeks!!

I don't want to use scripts all should be calcs. As I deploy this on the web.

Any ideas much appreciated.

Thanks,

Lance

Create an account or sign in to comment

https://fmforums.com/topic/61926-complex-date-summary-reports/
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.