Skip to Content

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

Line Item display

Hi,

I have Profit Ctr Dimension and in report i have the below display:

I am trying to display the field values as below:

  Services

  Proof

  910

  721

Im struck becuase it has string values and not able to trim only first 3 numbers dynamically

Thanks,

Dinya.

replied

Hi,

use this.

=Substr([Prof Ctr];1;Pos([Prof Ctr];"_")-1)

Amit

0 View this answer in context

Helpful Answer

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