We have a situation where, in the interest of trying to keep code rewrites to a minimum, we are investigating the possiblity of using a derived field.

We created a conditional derived field in DBDEF, and here is a simplified version of what we did:

If (10)
99
Else
88


The condition (10) is set to this:

Where ( vb_option_li = 10 )

So, in this new field, we reference another field in the table (vb_option_li), and if it is = 10, we want the derived value to be 99, otherwise it should be 88.

However, we are not able to see the derived value when we tried painting a screen. Also, when we do a derfldrpt, it shows zeros, where there should be numeric values. Anyone familiar with this functionality??