Hi

I have a calculation field which produces the result I want. The thing is that when I click on the field in Browse Mode I can see the text that has been generated by the calculation so I know it's working correctly, yet when I click away and commit the record the field displays a number. Please see attached screenshots so you can see what I mean.

Anybody got any ideas what could be causing this? I'm stumped.

Before:

After:

It seems you have set the result to type Number, instead of Text (and the field has number formatting applied to it).

Edited February 14, 200917 yr by Guest

Hi Comment

I'd checked that, but on going back through it all again I realised that it's a calculation which calls another calculation and that one was set to number.

Thanks for your help.