Need help for msdata expression = "IIF - 08-03-2006 , 05:29 PM
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
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.
<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" />
RE: Need help for msdata expression = "IIF - 08-03-2006 , 09:40 PM
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?
Microsoft Online Community Support
(This posting is provided "AS IS", with no warranties, and confers no
|Thread Tools||Search this Thread|