News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Smartlist Builder Calc...

Microsoft Dynamics GP (Archived)

Smartlist Builder Calculation - Rounding issue

(0) Share

Report

Report

Posted on by Cecile Dinh

585

I created a Calculation in SmartList Builder and here is the formula:

{Sales Transaction Amounts History:Extended Price} /{Sales Transaction History:Subtotal} *{RM Apply History File:Write Off Amount}

Based on my example, it will be 25/225*$5 = should be $.056 if rounded off instead of $0.55.

Do you have any idea how I can get the rounding off?

Thanks,
Cecile

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Cecile Dinh 585 on at

Like (0)

Report

RE: Smartlist Builder Calculation - Rounding issue

Hi Mike,

I tried it but didn't work. Any other thoughts?

Thanks,

Cecile
Mike Smith 6,840 on at

Like (0)

Report

RE: Smartlist Builder Calculation - Rounding issue

While I haven't attempted this, have you tried:

ROUND(({Sales Transaction Amounts History:Extended Price} /{Sales Transaction History:Subtotal} *{RM Apply History File:Write Off Amount}), 3)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,041 Super User 2025 Season 1

#2

Martin Dráb 231,856 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans