SUM on fields

[Wiz Bang Computers]

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

[mr_vodka]

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 December 20, 2005 by Guest
Typo in URL

[Wiz Bang Computers]

John,

THe link you provided is dead. Is there another link?

Thanks

[mr_vodka]

Try it now.