Finance | Project Operations, Human Resources, ...

Smartlist Builder Calculated Fields, CASE Query Help Please!

(0) Share

Report

Posted on by karlcgray

I am trying to change the output of a smartlist to match what a vendor requires, so instead of receiving Married, it needs to be '2', and male needs to be '1' etc. I figured this to be an easy project, but I seem to "break" the smartlist every time I write a case function to do this. here is an example:

CASE WHEN {Payroll Master:MARITAL STATUS} = 'SINGLE' THEN '1'
WHEN {Payroll Master:MARITAL STATUS} = 'MARRIED' THEN '2'
ELSE '1' END

CASE WHEN {Payroll Master:MARITAL STATUS} = 'single' then '1'

--WHEN {Payroll Master:MARITAL STATUS} = 'married' THEN '2'

ELSE '2'

END

I set the field name and the field type is string

Any help would be greatly appreciated!

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Suggested answer

karlcgray 10 on at

Like (0)

Report

RE: Smartlist Builder Calculated Fields, CASE Query Help Please!

[quote user="karlcgray"]CASE WHEN {Payroll Master:MARITAL STATUS} = 'SINGLE' THEN '1'
WHEN {Payroll Master:MARITAL STATUS} = 'MARRIED' THEN '2'
ELSE '1' END[/quote]
The solution is that because 'single' is from a drop down box instead of 'single', we just need to put 1 for this to work properly
Suggested answer

JanelleM on at

Like (0)

Report

RE: Smartlist Builder Calculated Fields, CASE Query Help Please!

Hi Karl,

Thank you for using Microsoft Communities.

Smartlist Builder was designed and supported by eOne solutions. If you have not found an answer to your Smartlist Builder calculated field, I would suggest contacting eOne support.

Thank you,

Janelle

Microsoft Support