Formula in transfer rule

[wamorgao]

Hello,

I'm pretty new in SAP BW and I having a problem in a transfer rule formula,

The field are coming with this data '137192 1' and causing me error in my process chain..

The correct data should be with 00 in the blank space '137192001'

Follow the formula in transfer rule

IF( STR_LEN( Nº doc.ref ) <> 10, IF( IS_INITIAL( Nº doc.ref ), '', CONCATENATE( IF( LEFT( Nº doc.ref, 2 ) = '00', '', '00' ), Nº doc.ref ) ), Nº doc.ref )

Is there anyone can help me? Thanks.

[varun_sawant]

What is the value in the source field used in formula before applying the formula? Also what is the target infoobject data type and length?