Strange Calculation Behaviour

[Jimmy Pewtress]

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:

[comment]

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, 2009 by Guest

[Jimmy Pewtress]

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.