S
savv32
I have built a report that shows approved and pending items for various
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.
Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00
Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00
My question is how do you get the "Total" calculated. I would like something
like that...
Thanks and hopefully that makes sense..
projects, now i can have multiple projects and multiple approved and pending
items below each project. I would like to add up the dollar amounts that
correspond to each approved or pending project. I have tried to use the
standard =sum([fieldname]), unfortunately that is adding everything up and
placing that amount under each heading.
Project 1
Approved Items
item a - $10,000.00
item b - $1,000.00
Total = $11,000.00
Pending Items
item c - $12,000.00
item d - $1,000.00
Total = $13,000.00
Project 2
Approved Items
item a - $500.00
Total = $500.00
Pending Items
item c - $12,000.00
Total = $12,000.00
My question is how do you get the "Total" calculated. I would like something
like that...
Thanks and hopefully that makes sense..