Issue with formatting totals in OTBI Analysis Table

Summary:
I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted the Coverage and Premium as currency however when adding the totals line to the Table it ignores the formatting and just treats it as a number. How do I get the totals at the bottom to be formatted as Currency?

Content (please ensure you mask any confidential information):

Criteria Tab:

SQL from Advanced Tab:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Benefits - Enrollments Real Time"."- Enrollment Results"."Benefit Amount" s_1,