>I have 2 Running Total fields used in a Formula field:
>
>
>iif({#t_Group2_Total_Calls} > 0 and {#t_Group2_Total_Orders} > 0, round(({#t_Group2_Total_Orders}/{#t_Group2_Total_Calls})*100,0),0)
>>
>I'm getting a 'Devision By Zero' error. According to this syntax, this
>should not be happing.
>
>The first part if the IIF() checks to see if BOTH totals are greater
>than zero, if IF the are, then devides one by another, otherwise
>returns zero.
>
>I can't seem to figure this out. It shouldn't be happening. Anyone know
>what to do here?
>
>Thanks
One thing I would try to check for the NULL value while comparing....In VFP, "Variable > NULL" returns False....
- Jayesh