OBIEE Grand Totals not Formmatting Correctly

Dennis Hancy

I have an analysis that includes several detail lines, along with a subtotal and a grand total.

The amount fields in the detail are properly formatted to include a currency symbol ($) and commas.  The subtotal also has the correct format.

However, the grand total does not have the same format.  There is no currency symbol ($) and no commas.

We have noticed, however, that if we wrap a function around this amount (for example, ABS(trans_amount), then the formatting is correct on the grand total.

Any idea what's causing this?  Or what we can do to fix this?

Thanks!

Dennis

Dennis Hancy

Here's a screen print showing the issue I am facing.

Thanks,

Dennis

SonPat99

Hello Dennis,,

What is the version of OBIEE you are using?

The same works for me in OBIEE 12.2.1.4.