BIP Data format on group-sum

Summary:

Content (required):

I'm trying to create a report in BIP (in a RTF file).

So I have used table wizard to create a for each on the values I need.

In the actuals columns the numbers come out as they shoud. For example like this:

However on my group totals it does not format and looks like this:

I need to find the correct format (looks like it is for when numbers higher than 1 mill)

The format that is automatically applied lookes like this:

###,##0.00

Can anyone help with this? Thanks in advance.

Version (include the version you are using, if applicable):