Currency required but string needed 1

[CRilliterate]

I need formula so if Balance (Currency) is 0 then display 'ALL'.
I wrote formula
IIF({?Balance}<>0,{?Balance},"'ALL'")
wich tells me that ALL should be currency. How can I change it so ALL is excepted?

Thanks

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[synapsevampire]

Try:

If {?Balance}<> 0 then
totext({?Balance},0,"")
else
"ALL"

-k

 

[CRilliterate]

STAR for help! THANKS

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server