>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/172849So, 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.
If it's not broken, fix it until it is.
My Blog