Good Morning All,
Here is what I am doing:
IIf((([Auction Data].[Sale_Price])<([211 Offered Sold StDev MY].[SPStDevMin])),([Auction Data] [Sale_Price])) Or IIf((([Auction Data].[Sale_Price])>([211 Offered Sold StDev MY].[SPStDevMax])),([Auction Data].[Sale_Price])) AS [SP Exp],
IIf((([Auction Data].[Days to Sell])<([211 Offered Sold StDev MY].[DTSStDevMin])),([Auction Data].[Days to Sell])) Or IIf((([Auction Data].[Days to Sell])>([211 Offered Sold StDev MY].[DTSStDevMax])),([Auction Data].[Days to Sell])) AS [DTS Exp]
Now my result is a -1 where it is out of range which if fine, but how I wrote this I was expecting the actual value from the field, either the sale_price in the column or the other would be the days to sell.
Any help would be appreciated.
T
Here is what I am doing:
IIf((([Auction Data].[Sale_Price])<([211 Offered Sold StDev MY].[SPStDevMin])),([Auction Data] [Sale_Price])) Or IIf((([Auction Data].[Sale_Price])>([211 Offered Sold StDev MY].[SPStDevMax])),([Auction Data].[Sale_Price])) AS [SP Exp],
IIf((([Auction Data].[Days to Sell])<([211 Offered Sold StDev MY].[DTSStDevMin])),([Auction Data].[Days to Sell])) Or IIf((([Auction Data].[Days to Sell])>([211 Offered Sold StDev MY].[DTSStDevMax])),([Auction Data].[Days to Sell])) AS [DTS Exp]
Now my result is a -1 where it is out of range which if fine, but how I wrote this I was expecting the actual value from the field, either the sale_price in the column or the other would be the days to sell.
Any help would be appreciated.
T