Formula Error

[dbltt25]

I have the following formula in a report of mine:

Right (Trim ({Cpftxt.FTXT}), Length (Trim ({Cpftxt.FTXT})) - 39)

The cpftxt.ftxt field is a string field that can hold 60 Characters.
When I do an error check in the Formula Editor, I have no errors. However when I preview the report I get the following error:

String length is less then 0 or not an integer.

Can anyone explain why I am getting this error message when I preview my report.
Any help is appreciated!!
Thanks

 

[bburnell]

Hi,
When you "trim" the string it is taking away all null or blank spaces. So the new length could now be 20 instead of 60. When you then subtract 39 (from 20), you get -19. That is where your error is coming from. I hope this helps!
Brett Please visit my websites!

http://smsforce.virtualave.net

http://www.b2ksolutions.net

http://www.goodguyz.com

 

[dbltt25]

Thank-You, that fixed my error!!

 

[bburnell]

You're welcome. I'm glad to have helped! Please visit my websites!

http://smsforce.virtualave.net

http://www.b2ksolutions.net

http://www.goodguyz.com