I have a report that lists our orders for the day. It groups them by the hour and I have a subtotal for each hour in the GF. When we have a new item the number is flagged so they can research it. The problem I have is that I need the report to not count this number in the hourly subtotal if it is a new item. I was able to get a formula to work if the order with the new item was the last order of the hour otherwise it added the number.

I have tried a few things but nothing has worked yet using those formulas. I am not quite sure which ({table.field}) or ({gorup}) to use. In the report I do have a formula  in the GF that counts all the items and totals how many different new items there are: