I have a report created by someone no longer with the company, whose CR skills FAR exceed my extremely basic knowledge. He wrote a daily report that sums job tickets by day by customer, except for one category of customer that is listed by individual job. His formula field that does this is below.

Shared MiscTotal as Number

formula = GroupName ({Ticket.CustomerName})
if left({Ticket.CustomerNum},1)="W" then
    formula="!Misc! - "+GroupName ({Ticket.CustomerName})
    MiscTotal=MiscTotal+Sum ({@Ticket Total}, {Ticket.CustomerName})
end if


Any ideas how I can tweak this so that all orders from customers whose customer # begins with W are added together as one total, instead of each order listed separately?

Thanks!

I'll give that a try. Probably be next week before I get a chance to look at it. I'll let you know. Thanks.