Skip to Content

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

Select portion of a field

I looked this up and I did not find any threads that talked about this.

Can any one post an example of a running total formula that only looks for a portion of the field.

I have a field that is {CAWP.WP} in the fiels the text string is 10120430.100 tru .900 ect

I need to omly select the .900 prtion of the field to return the desired report number

Former Member
replied

Hi John

Create a formula like this..

mid(,1,len()-4)

This will work only if the lenght of the fields that you want to extract is constant.

Hope this helps.

Regards

Ankeet

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