Large number value pushing out as scientific E number

Summary:

I have a rtf template that must show opening balance, total invoices, total credit memos, etc and a closing balance. My amount coluns are pushing out values like

Content (required):

I have formatted the columns as below

<?format-number:sum(OPENING_BALANCE);'999G999D99'?>

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

Bi Publisher version 12.2.1.4.0

Code Snippet (add any code snippets that support your topic, if applicable):