Avatar of RUA Volunteer2?
RUA Volunteer2?
Flag for United States of America asked on

Business Objects Web Intelligence Reporting. How do you create a Running Total that counts the number of Lines for a given Section (group)

THIS IS NOT CRYSTAL REPORTS.....I already know how to do this in CR so that you know.
The problem:

I have Student IDs
I need to count the number of Discrepancies where the Student passed or failed a class..
We collect the data in a Oracle database and check to see if the grade is passing or not.
If the grade is passing then the row is not flagged
If the grade is failing the row is flagged and brought into the report.
So we have
Student             Course          Grade        Counter           RunTotal
Billy Bobby          MATH              D-                 1                      1
Billy Bobby          ENG                 F                  1                      2
Billy Bobby          PHY                 D-                 1                      3              

Ricky Bobby        PHY                 D-                 2                      1
Ricky Bobby        CHM                D-                 2                      2
Ricky Bobby        MATH              D-                 2                      3
Ricky Bobby        BIO                  D-                 2                      4

Billy Bob              PHY                 D-                 3                      1
Billy Bob              MATH               F                  3                      2

If the number of Classes taken that are a failing Grades exceed 3 we need to filter the rest out and show them in the report. This is our way of helping identify students, athletes etc that we can recommend for programs to help get them back on track and put them in tutoring programs as well as check closely the evaluation of the teachers and their performance.

How can I show only the students that have more than 3 failing grades in BOXI Web Intelligence Rich Client.
Can I use a RunningCount or RunningSum combined with some other function?
I was trying this and it does not work Class Nbr is unique and Student ID is too. What am I doing wrong...?
I cannot figure out how to get it to reset to ZERO after the Student ID changes. (like you would in Crystal Reports)
=RunningCount([Class Nbr]) In ([var_Student_ID])
If so how do I write that formula.
Please advise.
DB Reporting ToolsEnterprise Software

Avatar of undefined
Last Comment
RUA Volunteer2?

8/22/2022 - Mon
SOLUTION
no worries :-) no nothing

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
RUA Volunteer2?

ASKER
Can you give me a better example like this.
It is probably so simple I am making it complicated.
When you say " select the course column then data"
and use Distinct Count.....
Are these all functions or settings ? Could you give an example more like this so I can follow the format..?

=RunningCount([Course]) In ([Student_ID])

I am clear on the filtering
ASKER CERTIFIED SOLUTION
no worries :-) no nothing

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
RUA Volunteer2?

ASKER
That got my column on the right hand side working correctly thanks to you.
Now I realized there is one more step I did not realize would be an issue.
On the right hand side it is showing the values greater than 3
If I filter on that how would I get it to show all 3 lines of records.......1,2,3 or 1,2,3,4
still omiting the records less than 3
Any thoughts on that....thank you.  

StudentCourseFailures.png
RUA Volunteer2?

ASKER
The final solution seems to be this.
=RunningCount([Students].[StudentId];([Class Nbr]))

Thank you for your help. There is another posting out there for a related question. I thought I would let you know thanks for the help.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
RUA Volunteer2?

ASKER
How can I reopen this question....It did not work for some reason....?

apparently having one of my dimensions in the report is impacting the way the Running Total Works.
I have seen it work correctly then I got finished dropping in all the fields I needed I looked back over at the Legal sized report in my Running Total column at the far right and it was showing the number 1 all the way down the page ...... I am nut sure why because I added dimensions from the same data provider....?
Baffled. Any thoughts.