Skip to Content

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

Suppress only the maximum line value

I have a report that I am filtering out certain values. In the details section I would like to only show the highest valued that is associated with the highest line. I have tried the suppress option in Selection Expert>Suppress (No Drill-Down) and put in this formula:

if {NOTE_EDIT_TRAIL.LINE} <> maximum({NOTE_EDIT_TRAIL.LINE}) then true

else false

This will suppress values that should not be suppressed. I think what is happening is there are higher values associated to the record that I am filtering out in my Select Expert. Should I use a whileprintingrerords formula?

Former Member
replied

Hi Doug,

Here's what you can try:

1) Insert a Group on a primary key field

2) Go to the Record Sort Expert and insert a 'Descending' sort on the LINE field

3) Place all fields on the Group Header

4) Suppress the Details section

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question