I have a report that groups orders by hour. In the group footer it adds a column and if the total is more than 100 it rounds it to 100. The problem I have is that I need to do a grand total in the report footer and add all of those numbers and if it rounded a number to 100 I want it to treat it as 100 and not the actual number, so using the example below I want my report to display 275 not 325 .

It worked if the number didnt go over the next hundred. So for example if the total of the column was 450 it would round it down to 400 and not to 100.

That was it. I am not sure if there is something else in the formula or in my report because it starts out with a begining balance of 100. I ran it for several days and I always get the same begining.