Jump to content

SUM on fields


Wiz Bang Computers
 Share

This topic is 5758 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a report that lists payemnts received ona specific day. I woudl like to SUM up the payments amounts for the day and get a count on the number of entries.

I ahve tired to doa Column List/Report format, group by Payment Date and tell it I was sub totals and grand totals. When I get to the page in the wizard to set up the subtitals it will not allow me to selelct a field.

My report uses the following fields:

Transaction Number (text)

Account Number (number)

Payment Date (Date)

Payment Amount (Number/Currency)

Payment Fee (Number/Currency)

Can someone please provide some guideance? Am I suing the wrong format or might I have a setting wrong on one the the filds and it is set to not summarize?

Thank you,

WizBang Computer

Link to comment
Share on other sites

Hi I know this solution was made with FM6 due to the fact that the OP was using FM6, but you can convert the files to FM8 by just opening the files in FM8 (or dragging and dropping).

In that solution there should be examples of reports that are run for specific days with the total amount as well as a count of invoices.

Hi i know this solution I made was made with FM6 because the OP was using FM6, but you can convert the files to FM7.

Click Here

Edited by Guest
Typo in URL
Link to comment
Share on other sites

This topic is 5758 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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