We have a IDO we build with a derived field, the similar to the DerNetPrice in the SLcoitems IDO has a slight difference. When we run the dataview it just spins, (it did not before we added the below) What are we doing wrong.
Please help, the IDO has co table and coitem table joined on the co_num..
ROUND(ISNULL(qty_ordered_conv,0) * (1.0 - ISNULL(disc,0) / 100.0) * ISNULL(price_conv,0), 2)
