Compare two characteristics

[Former Member]

I need to return values in a query where the Characteristic "MRP Controller" and Characteristic "Work Center" are not the same. How can I do this? Keep in mind that they are both compounded to Plant.

Thanks!

[Former Member · Accepted solution]

You will either need to use a virtual KF, or, write some front-end code (VB in excel, or JScript or table interface class etc for web template).

If you can assign a numeric master data attribute to both these in the master data, you can then use a replacement path formula (one each) to get those numeric values, and build a suitable formula to show only the rows that you need.