Crystal Reports: Difference of two hierarcy nodes

[pr1ya]

Hi,
I have a requirement to get the difference of two nodes.
Here is example


2010
Revenue:
Ratable Revenue 492,997
Product Revenue 34,008,616
Services Revenue 4,449,767
Total Revenue 38,951,380
Cost of Sales:
Ratable Cost 263,208
Product Cost 13,178,913
Service Cost 1,692,402
Restructuring Cost 0.00
Total Cost of Sales 15,134,523
Gross Margin 23,816,856
Gross Margin% 61.1%

Here I should get the difference of TOTAL REVENUE and TOTAL COST OF SALES
GROSS MARGIN/TOTAL REVENUE*100 (Round to first decimal)
GROSS MARGIN=GROSS MARGIN/TOTAL REVENUE*100 (Round to first decimal)

How can i achieve that in crystal reports.
Any help please

 

[IanWaterman]

Easiest way is to use a Running total

#revenue

Use a sum of your numeric field and in evaluate use a formula

TypeField = 'Revenue' // Type field is field used to grop on Revenue and costs

Reset = Never

Do same for Cost of Sales

You can then use these RTs in formula to calculate Margin etc.

Ian