RE: IIF Problem

2001-01-19 Thread Mike Townend
The problem is that when CYOriginal EQ 0 the following code is run NumberFormat(100*Change/CYOriginal, '__._') and as CYOriginal=0 then you cannot divide (100*Change) by 0 HTH Mike -Original Message- From: Drechsler, Jennifer [mailto:[EMAIL PROTECTED]] Sent: Friday, January

RE: IIF Problem

2001-01-19 Thread Stephen Moretti
Hi Jennifer, Can anyone tell me why this isn't working. I can't stare at this any longer. The output runs fine until there is a CYOriginal = 0. Blows up. Help, Please. CFOUTPUT#IIF(CYOriginal EQ 0, IIF(Requested GT 0, DE("100.0"), DE("0.0")), NumberFormt(100*Change/CYOriginal,

RE: IIF Problem

2001-01-19 Thread Philip Arnold - ASP
Can anyone tell me why this isn't working. I can't stare at this any longer. The output runs fine until there is a CYOriginal = 0. Blows up. Help, Please. CFOUTPUT#IIF(CYOriginal EQ 0, IIF(Requested GT 0, DE("100.0"), DE("0.0")), NumberFormt(100*Change/CYOriginal, '__._'))#/CFOUTPUT I

RE: IIF Problem

2001-01-19 Thread Philip Arnold - ASP
CFOUTPUT#IIF(CYOriginal EQ 0, IIF(Requested GT 0, DE("100.0"), DE("0.0")), NumberFormt(100*Change/CYOriginal, '__._'))#/CFOUTPUT The problem is that when CYOriginal EQ 0 the following code is run NumberFormat(100*Change/CYOriginal, '__._') and as CYOriginal=0 then you cannot