Formula is not working

[Former Member]

Hi Experts,

Please can any one explain me regarding the below formula because I already place this formula at repeative area footer part but it is not working.

substring('/n/n/n/n/n/n/n/n/n/n/n/n',0,2*(12-LineNum())

Please help to resolve this issue.

Regards

Amit Tyagi

[Former Member]

hi Amit,

You r used this /n is not correct, Use this \n. and you did not put ) end of formula, thats it.

Try this, it will work.

Substring('\n\n\n\n\n\n\n\n\n\n\n\n',0,2*(12-LineNum()))

Regards,

Madhan.

[Former Member]

Hi Expert,

I did the same as you convey but the problem remain the same.Please do some need ful.

Regards

Amit Tyagi

[Former Member]

hi Amit,

Do this,

->> Open your PLD and Create new Formula Field and put ths formula,

Substring('\n\n\n\n\n\n\n\n\n\n\n\n',0,2*(12-LineNum()))

Dont Copy and Paste Fields in Repetetive Area Footer. If you copy and paste Fields and put formula, it is not working properly so you can Create new Formula Field in Repetetive Area Footer and put Formula.

Regards,

Madhan.