How do I write this expression for a SalesLogix calulated field?
CASE WHEN ISNULL(Repl_Quote, '') <> '' AND ISNULL(Repair_Quote, '') <> '' THEN 'Replacement & Repair'
ELSE CASE WHEN ISNULL(Repl_Quote, '') <> '' THEN 'Repair' ELSE 'Replacement' END
I need this field to be displayed in a simple grid.
You can't do that as a SalesLogix calculated field.
If you don't have to worry about synchronization, you could instead use SQL Computed columns.
You go into SLX and add a Column, lets call it CAL1 (use whatever name you want to).
Once the column has been created, go into SQL and change its definition, place the Case statement into the Computation of the column.
From SLX, the column will look and feel like any other column.