web

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

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Using INT Value in Mat...

Finance | Project Operations, Human Resources, ...

Answered

Using INT Value in Math - SQL

(0) Share

Report

Report

Posted on by Bill Campbell

12

Ok, someone out there knows how to do this - I just can not find the right combination of SQL to make it work.

Field : PUnits - int

Values: 6000, 5000, 900, 50

What I know is to do the math to get from PUnits * PRate = PLineTotal

need to divide Punits by 100 to get to the right decimal value

SO

6000 = 60.00
5000 = 50.00
900 = 9.00
50 = 0.00

(PRate *(PUnits/100)) -- all work when the value in PUnits has 3 or more characters -

but when the PUnits value = 50 and I apply the same rule then the value ( PUnits/100 ) 50 / 100 = 0000

I am sure that it is a matter of figuring out the right way to 'format' PUnits first.

Thanks.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

James McCullough 397 on at

Like (0)

Report
Copy link

Link copied!
This is the way I just did it:

SELECT CONVERT(DECIMAL, 50) / CONVERT(DECIMAL, 100.00)

I mean, it's heavy handed, but it will do it. The problem is that SQL thinks that 50 and 100 are integers, and so is enforcing integer math on it.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks that got me the desired result.

Was this reply helpful? Yes No
James McCullough 397 on at

Like (0)

Report
Copy link

Link copied!

Hey Bill:

Could you hit it as a "verified answer" then please? I appreciate it greatly, as I'm just effectively getting started here. :)

Was this reply helpful? Yes No
James McCullough 397 on at

Like (0)

Report
Copy link

Link copied!

And HEY! You're a fellow Albertan! I'm in Calgary! :D

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Abhilash Warrier 635 Super User 2026 Season 1

#2

André Arnaud de Cal... 595 Super User 2026 Season 1

#3

Giorgio Bonacorsi 557

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans