# summarizing a running field.

Hi guys. Please help. Im creating a report and i do have this formula

**@proc_days**

**WhilePrintingRecords;**

**DateVar Array Holidays;**

**Local DatetimeVar Start := {@Adjusted Item Create Timestamp};**

**Local DatetimeVar End := {@zzLast Edit Date};**

**local numbervar days;**

**Local NumberVar i;**

**For i := 1 to Count(Holidays) do**

**(**

** if DayOfWeek (Holidays[i]) in 2 to 7 and Holidays[i] in [Start to End] then**

** days := days + 1;**

**);**

**Datediff("d", Start, End) - Datediff("ww", Start, End, crSunday) - days;**

ir computes days of processing of orders excluding the holidays and sundays.

the problem is how can i summarize this @proc_days?

I want to total the orders with 0-3days processing , 4-7days, and 7-15 days.

i tried using running fields but @proc_days dont have on the field list.

my idea is to create a formula like this

**if {STORER.SUSR2} = 'FSS' then **

** (if {@proc_days2}<=3 then 1)**

** else 0**

where **@proc_days2** code is:

**if{@proc days}>0 then**

** {@proc days} else**

**0**

the formula is showing orders with 3days and below processing.

i just need to summarize all of those for my report to be finish.

-karlo

##### Abhilash Kumar replied

Hi Karlo,

Please see if this works:

1) Create a formula (@proc_days3) with this code:

**whileprintingrecords;**

**numbervar count_3;**

**if {STORER.SUSR2} = 'FSS' AND (****{@proc_days} IN [1 to 3])**

** then count_3 := count_3 + 1;**

2) Create a formula (@proc_days7) with this code:

**whileprintingrecords;**

**numbervar count_7;**

**if {STORER.SUSR2} = 'FSS' AND (****{@proc_days} IN [4 to 7])**

** then count_7 := count_7 + 1;**

3) Create a formula (@proc_days15) with this code:

**whileprintingrecords;**

**numbervar count_15;**

**if {STORER.SUSR2} = 'FSS' AND (****{@proc_days} IN [8 to 15])**

** then count_15 := count_15 + 1;**

**Place all these formulae on the same section as the @Proc_days formula**

**4) Create one last formula on the Report Footer with this code:**

**whileprintingrecords;**

**numbervar count_3;**

**numbervar count_7;**

**numbervar count_15;**

**"Total Orders in 0 - 3 days :"&count_3;**

**"Total Orders in 4 - 7 days :"&count_7;**

**"Total Orders in 8 - 15 days :"&count_15;**

**Right-click this field > format field > common tab > check the 'Can Grow' option**

**-Abhilash**