Skip to Content

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

Problem with Mid Function

Hello,

i have in datebase index like this 60001000.  I am trying display it like this 6000 1000. I used mid function in formula:

if {PKL1.BaseObject}=17 then {MID({RDR1.ItemCode}, 1, 4); MID({RDR1.ItemCode}, 4); }

else {MID({INV1.ItemCode}, 1, 4); MID({INV1.ItemCode},4)} 

I have error that this field doesnt exist. When i remove mid function its display properly.

Former Member
replied

Hi Krystian,

Try:

if {PKL1.BaseObject}=17 then

MID({RDR1.ItemCode}, 1, 4) &' ' & MID({RDR1.ItemCode}, 4)

else MID({INV1.ItemCode}, 1, 4) & ' ' & MID({INV1.ItemCode},4)

-Abhilash

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