>>>Hi everybody,
>>>
>>>Is there a way to specify not to show 0, if Numeric Value=0 in Transform?
>>>Say, Price=0, transform(Price,'$999,999,999') shows $0. What should I do?
>>
>>Add an @Z in from of your format:
>>
>>?transform($0,"@Z $999,999,999")
>
>Great, thanks a lot. It's easy, than Erik's IIF :)))
Also note that if you don't put the space between the Z and the $, then you'll get your format with the $ right up against your number instead of to the left edge of the field.
price = 50
?TRANSFORM(price,"@Z $999,999,999") -- "$ 50"
?TRANSFORM(price,"@Z$999,999,999") -- " $50"