I am using below expression in xsd...
I am getting devide by zero error.

For ur information I am filling the dataset with the results obtained from
Stored procedure.
Now again I need to calculate one field which is the divison of two fields
returned from SP.
Please notice that the third field is not available in the database. We need
to calculate inside xsd using the two fields returned from SP.
Please help

<xs:element name="CALC_BLDG_SBMT_PER_SQFT_AMT" type="xs:decimal"
msdata:Expression="IIF((IsNULL(TOTFLRAREASQFTNBR, 0) 0),
(IsNULL(BLDG_VAL_AMT, 0) / TOTFLRAREASQFTNBR ),NULL)" minOccurs="0" />
--
Vishnu

Hi Vishnu,

I tried the expression on my machine. However, I tried divisor and dividend
columns with NULL and 0 values, none of the cases gives devide by 0
exception. Could you check which value in the returned rows gives this
error? Also, are there any other calculated rows in the table?

Kevin Yu
Microsoft Online Community Support
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)