Is there a way to compare the text from one field to the text of a second field?
Background: Our Purchasing staff do not always update all fields in Lawson appropriately. We are trying to generate a report to identify when the Vendor Agreement Item Description does not equal the Vendor Item Description. The purchasing staff then go in and correct the errors. I've tried a set analysis -see below - but that didn't work. I've tried an IF statement which works but is way too slow. Is there a better alternative?
You can do that in the script itself by adding a flag field which checks whether [PO Vendor Agreement Item Description] is the same as [PO Vendor Item Vendor Item Description] , if the condition is true then the flag is 1 and if false the flag is 0. You then sum ([PO Vendor Agreement Lawson UOM Cost] * Flag) or Count() the flags. Hope that helps.
