summation format in a table

I have a problem with a table in a report.

In this table I have three columns to expose the daily, monthly and annual revenue by department.

The problem is in the year grand total field:  in this field the data format remains always in scientific notation even if I select currency (or numeric) format. Day and Month grand total fields instead are shown correctly and they can normally switch from numeric to currency (and even %) format.

I suppose the problem is related to the magnitude of the number in the field (hundreds of thousands in day and month, millions in year), but I don't know how change this.