question about % change

[rrmcguire]

I have 2 formulas "current total charges" and "previous total charges". Current Total Charges is:

if {SHIPMENTS_TTX.PICKUPDATE} >= {@Current Min} and
{SHIPMENTS_TTX.PICKUPDATE} <= {@Current Max} then {SHIPMENTS_TTX.TOTALCHARGES}
else 0

@Current Min is the minimum of a parameter field date range

@Current Max is the maximum of a parameter field date range


Previous Total Charges is:

if {SHIPMENTS_TTX.PICKUPDATE} >= {@Previous Min} and
{SHIPMENTS_TTX.PICKUPDATE} <= {@Previous Max} then {SHIPMENTS_TTX.TOTALCHARGES}
else 0


where @previous min is the minimum of a parameter date range

and @previous max is the maximum of a parameter date range


I then have 2 summary's, Sum of current total charges and Sum of previous total charges


How do I find the percent change between the Sum of the current total charges and the Sum of the previous total charges

 

[MCuthill]

rrmcguire,

I don't have crystal in front of me, but I am wondering if creating a formula field like the following would work:

(Sum(Current) - Sum(Previous)) / Sum(Previous)

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."