Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Running Total In Group Header

I have a report where I need to perform a distinct count of records with a specified status level for multiple group levels. I am using a Running Total to perform a conditional count. The problem is that in order to display the multiple group levels in the proper order, I have to post the values in the group headers, where the running total hasn't yet calculated any value.

I tried creating a formula for the detail record that applies the condition, and then performing a distinct count on that formula, but it is counting 0 (if the condition fails) as a value, giving me a count 1 too big. I would just subtract 1 from the distinct count, but I can't count on there not actually being a valid zero value.

Fuskie

Who wonders if he is overthinking this...

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question