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.

Monthly Sales Report - GP percentage calc not working

lizzie
in Calculation Engine (Define Fields)

Featured Replies

Greetings!

I am really battling with a final calculation for one of my sales reports. The report I have created is a sub-summary report to analyse total sales, GP and GP Percentage per department of products sold (i.e. hardware vs software vs. consumables etc).

My report is great so far. I just cannot get the GP percentage calculation to be dynamic i.e. when I run the report over three months, my GP% calculates the entire GP Sum / Total of Recom extended. I have tried to do a sub-summary of GP Sum by Month and a sub-summary of Total of Recom extended by month and use these in a GetSummary calculation but the calculation fudges out.

Does anyone know how I can resolve this issue?

Do you require more information from me before being able to identify/diagnose the problem?

Edited by Guest

Do you require more information from me before being able to identify/diagnose the problem?

This is too often the case, but perhaps is it enought to lead you these template:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000726

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000752

--sd

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.