BI Publisher (MOSC)

MOSC Banner

Rounding a Sum

edited Mar 30, 2017 4:16PM in BI Publisher (MOSC) 3 commentsAnswered ✓

I have a BIP report that shows the following for grand totals.

This is almost correct. The total should be 6538.58 but I am getting 6538.57.  I am not able to figure out what round command I want to use. 

This is the properties of this field as is..

<?sum(GROSS)?>

I have tried

<?xdofx:round(sum(GROSS),2)?> get an error. 

I have tried

<?round(sum(GROSS))?> and get 6539.  That makes sense to me but not the number that I want. 

What am I missing?  Any help is most appreciated.  This seems like it should be more simple than this.  :-)

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center