Oracle Analytics Cloud and Server

OBIEE Grand Totals not Formmatting Correctly

Received Response
24
Views
2
Comments

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

Answers

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

    BI Grand Total.jpg

    Thanks,

    Dennis

  • SonPat99
    SonPat99 ✭✭✭✭✭

    Hello Dennis,,

    What is the version of OBIEE you are using?

    The same works for me in OBIEE 12.2.1.4.

    pastedImage_0.png