Sum Values for matching dates

Sasha2016
Sasha2016 used Ask the Experts™
on
List all used Dates in Report, and sum corresponding Values.

Hello,
I'm trying to add Value totals to Purchase Orders that have multiple receipts.
I have formula fields for Date and Value. (rffTransactionDate and rffValue)

I'm trying to find a way to do following:
after last record, list all dates that are used in Report (if same date is listed in multiple lines, just print it once)
Formula that would do look at that list of dates, and sum all Values that have that same date in above records (see attached)

 screenshot
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What formulas are you using?

Can you group on the date field?

Can you upload the report file?

mlmcc
Professor of MIS at Penn State Erie and Owner, Millet Software
Commented:
Simply insert a CrossTab in the report footer.
Set the CrossTab row field to the date and set the summarized item to be the Extended Price.

Author

Commented:
Thank you both!
I ended up using both suggestions - formulas had to be modified (had some suppress conditions I had to change), and Cross-Tab did the trick after that.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial