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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

JanelleM Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

karlcgray 10 on at

Like (0)

Report
Copy link

Link copied!

[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

Was this reply helpful? Yes No