BI Publisher (MOSC)

MOSC Banner

Custom Formula with Nested Function has incorrect results

edited May 20, 2019 2:37PM in BI Publisher (MOSC) 1 commentAnswered ✓

I have 2 data sets that both select a year value and then a count, grouped by the year. I'm trying to use a custom formula that basically adds these summations together.

(summation(count from data set A) + summation(count from data set )

For some reason I always get the incorrect result.

Here's the layout.

See below for the formula used on the template.

Am I doing anything wrong?

Tagged:

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