web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Calculated Field in Sm...

Microsoft Dynamics GP (Archived)

Calculated Field in Smartlist builder

(0) Share

Report

Report

Posted on by NERFANVIL

35

When I add a Calculated field in smarlist builder. Set my Field Name as Inks, Field Type as string. Then the Calculation as

CASE WHEN {Order Form:# Inks} = 0 THEN ''
ELSE CONVERT (CHAR(3),{Order Form:# Inks})
END

The SQL Code is validated, but when I run the smartlist, I get all blanks all the time.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

L Vail 65,271 on at

Like (0)

Report

RE: Calculated Field in Smartlist builder

Hi,

What table are you using in your calculation? Are you using the calculated field in the formula? Where are you setting its value. I'm probably not getting this, but it looks like you test the value of the calculated field first. It will always be 0 if you haven't set a value. Would you please give a little more information on what you are trying to accomplish and against which table you are running this.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

NERFANVIL 35 on at

Like (0)

Report

RE: Calculated Field in Smartlist builder

Hi,

I figured it out. I guess it wanted a decimal to compare to?!?

CASE WHEN {Order Form:#Inks} = 0.00000 THEN ''

ELSE CAST( CAST({Order Form:#Inks} AS INT) AS VARCHAR(3))

END

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans