News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) How to separate the ce...

Microsoft Dynamics NAV (Archived)

How to separate the cents from an amount and put it in another field - SSRS

(1) Share

Report

Report

Posted on by Suhail

140

Hi All,

Sorry this question for reporting issue but maybe the solution in NAV, so my question is i have an amount such as 180.60 USD i want separate the 0.60 to another filed and 180 in another filed also for reporting purpose in SSRS.

Do you have any idea how we can do it in NAV development as coding or in SSRS ?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Suhail 140 on at

Like (0)

Report

RE: How to separate the cents from an amount and put it in another field - SSRS

it's Fixed, by using this code in C/AL:

IntegerDebitAmount := "Debit Amount" DIV 1; //= 99
DecimalDebitAmount := "Debit Amount" MOD 1 * 100;

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans