>Hi,
>
>A client just asked me to display negative amounts in textboxes with the bracket, like (100.00) intead of -100.00. I did that for the reports, but in the textbox I did not find a formatting option for that. So I need to transform with "@(". But how can I combine with thousand seperator?
>
>
TRANSFORM(-1000000.00,"@(###,###.##")
This works for me, note the space between ( and #
? TRANSFORM(-1000000.00,"@( ###,###,###.##")
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges