BI Publisher (MOSC)

MOSC Banner

count without zero value in rtf

edited Jan 20, 2024 4:58PM in BI Publisher (MOSC) 3 commentsAnswered

I am creating a matrix report, used the following to find the average:

<?sum(current-group()/SALES_QTY) div count(current-group()/SALES_QTY))?>

but now need to find the count without zero.

for example:

amount

12

0

3

4

the count = 3

can anyone help?

br

Muhammad Nadeem

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