Problems with Sum(fld, condFld) Function

[PositiveParrot]

I have an itemised phone bill database which includes the fields PhoneNumber (phone being billed) and CallCost. I'm trying to get itemised bills but only for phones whose total phone cost is greater than £25.

My first try was to use the condition in the record selection

Sum({CallCost}, {PhoneNumber}) > 25

but I got the messages

The summary/running total field could not be created.
There must be a group that matches this field.

So then I set up the field PhoneNumber as a group field but I got the message

This function cannot be used because it must be evaluated later

which made some sense when I read the 'WhileReadingRecords' help notes but now I'm stuck.

Any ideas would be much appreciated.

I'm using version 7.0.2.200

Thanks

PP

 

[mbarron]

You are getting this error because you are trying to enter the formula in the Records selection area and not the Group selection area.

Goto Record/Edit Selection Formula> Groups

Or if you are using the Select Expert

Click on the Show formula button and choose the Groups option.

Mike

 

[PositiveParrot]

Mike,

We were intending to use the scheduler and when we set the phone number up as a group field, a Group selection area became available as well as a record selection area.

Thanks for your help on this - it will be very useful to us now we can set up group formulae.

PP