Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Smartlist Builder Calculated Fields, CASE Query Help Please!

editSubscribe (0) ShareShare
ReportReport
Posted on by 10

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

or 

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! 

  • Suggested answer
    karlcgray Profile Picture
    karlcgray 10 on at
    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 Profile Picture
    JanelleM on at
    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans