>Naomi,
>its ok for me to receive a reply after your session. Anyway it is 23:30 already in Holland.
>I would like to have my number formatted to 999,999.99 + only if a condition is true, otherwise the format will remain 999,999.99.
>So if condition is true it would show as e.g. 78,796.00 + and if condition is false it could be 67,560.00 or (in case it is negative -67,560.00)
>Bye for now,
>will read you tom.
>
>Koen

Hi Koen,

I was trying to find HELP for a TRANSFORM() function in order to figure out the correct format, but I found this article instead http://support.microsoft.com/kb/172849

So, I guess the problem is by design and my suggestion was not supposed to work as I thought it should if you tried to use it for the calculated field. However, it should have worked for the normal field.