Hi,

I am a bit lost here and need some help. I have the following fields in my report:

- Called Number<Text>
- Rate<Number>
- Duration <Number>
- Price<Formula> => Rate * Duration

Normally to simply sum the "Price" field I'd write: =>SUM({Cost_report.Calls})

However, I need to create two Summary fields. Each one only sums a subset of the the "Price" column based on a condition in the "CalledNumber" column as follows:

CalledNumber                   Price
------------------                   ------
97184323                          2.5
92343323                          23.00
84755543                          30.5
83343321                          8.0
94532234                          10.5
       

Sum for only numbers that begin with 9==> 36.00
Sum for only numbers that begin with 8==> 38.5

Any ideas?!!!


Please used VB Syntax if possible.

Thanks

Thanks.. but I figured that I can use LEFT function to do it as well. I still need  to do the conditional summation in one formula field but aparently it cannot be done.

Thanks all for your help. I used the LEFT function and used the two running totals technique.

Thanks