Sum a formula field 1

[hlb6]

I need a grand total on the following formula (running totals will not work - it does not look at my conditions , so the running total is incorrect):
the name of the formula below is MeterUsage

IF COUNT ({work_order_test;1.Meter}, {work_order_test;1.EquipNumber})> 1
THEN
(IF (MAXIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}) -
MINIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}))> 0
THEN(MAXIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}) -
MINIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}))
ELSE 0.00)
ELSE

IF COUNT ({work_order_test;1.Meter}, {work_order_test;1.EquipNumber})= 1
THEN
(IF (MAXIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}) -
MINIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}))> 0
THEN(MAXIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}) -
MINIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}))
ELSE 0.00)
ELSE
MAXIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber}) -
MINIMUM({work_order_test;1.Meter},{work_order_test;1.EquipNumber})

 

[pmax9999]

The simplest way would be to use a vaiable to accrue the total. Amend your formula by adding the following code before and after your existing code:

WhilePrintingRecords;
Global NumberVar TOT;
Local  NumberVar REC :=

[COLOR=#EF2929][existing code here][/color]

;
TOT := TOT + REC;

REC

Then create the following formula and add it to the Report Footer to dislay the total:

WhilePrintingRecords;
Global NumberVar TOT;

Cheers
Pete

 

[hlb6]

Works like a charm!! Thanks Pete - your an angel!!!!!