IDO build derived field

Steve Poye

We have a IDO we build with a derived field, the same at the DerNetPrice in the SLcoitems IDO with 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, 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)

nfelicioni

It is best practice to use the column table alias when creating derived fields. Since the disc field exists in both the co and coitem table, the column table alias field needs to be provided so it knows SQL knows the context to pull the data.

0712050809193544.doc