Dear All,

I current design a report, but I face a problem on the ticket no grouping. I have few group of ticket no which all store into ticketno, for example :
Ticket No 1st group =  33092,
2n group of number = AS0000006P
3rd group of number =AS00070001

so, my report need to able to group the normal Ticket number and Abnormal Ticket No in the report.

How to differential the abnormal ticket no, is any ticket no end with character word at the end of the no.

Does any one can help me on how to solve this type of report filtering.

Thanks

Shiloh

Hi Lockwelle，

Yes, is work in group by product plant, type and also grade. I using formula to work on it's just dont know how to add in additional condition into my formula.

I will try your suggestion into the formula.

Thanks for help