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