Thread: Grouping with calculated field in report
View Single Post
  #2 (permalink)  
Old August 8th, 2007, 11:22 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,534, Level: 42
Points: 9,534, Level: 42 Points: 9,534, Level: 42 Points: 9,534, Level: 42
Activity: 11%
Activity: 11% Activity: 11% Activity: 11%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,064
Thanks: 0
Thanked 10 Times in 10 Posts
Default
If there is only one record in your detail section, then just drop some text boxes on the detail section and add this text:


6000 Gross Margin: =Sum([3000]-[5000)

9000 Net Profit: =Sum(([3000]-[5000])-[7000])

I am assuming the field names.

Did that help?


mmcdonal
Reply With Quote