Skip to Content

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

How to get the record no. in details section

Hi,

I need your help and assistant in getting the record no. or sequence no. in the details for each displayed record. My report looks like below:

GH1: {Instrument.Name}

Details: {Deal_No} {@Sum_Formula}

GF1: {Instrument.Name}

I need the record no. to be shown before the {Deal_No} in the details section and I want use it in my formula. Currently, I tried to use a running total to get the count for the {Deal_No} and to be reset on changing of group GH1: {Instrument.Name}, but unfortunately it gave me wrong record no. because there are suppressed {Deal_No} and sometimes the record number will start from 28 or 120 in some groups where I want for each group to start by showing no.1 and the next record should have no.2 ...etc.

In the {@Sum_Formula}, I need to apply the following condition:

If it is the first record in each group then

total= {@OB}+{@DR}+{@CR}

else

total=total+{@DR}+{@CR}


So please help me getting the first record in each group and to apply the formula.


Tags:
Former Member
replied

You said:

"I tried to use a running total to get the count for the {Deal_No} and to be reset on changing of group GH1: {Instrument.Name}, but unfortunately it gave me wrong record no. because there are suppressed {Deal_No}..."

It is the formula you are using to suppress {Deal_No} on your report.  Since you're talking about Details sections, I assume it's in the Suppression Formula in the Section Expert for your Details section.  Copy that formula and then use it in the Evaluate section of the Running Total expert - type "Not(", paste the formula, and then type ")" (don't include the quotes).

-Dell

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