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, ... Add zero's prefix ...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Add zero's prefix in real value with decimal

(0) Share

Report

Report

Posted on by baduru hameed

115

Hi All,

I want to add number of zero's prefix of real field value(Customer balance) like (#00000000000.00) this format.

Ex: customer balance round of 341.75 means I need this value to be this #00000000341.75 format

Any help

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello baduru,

Is this issue related to AX2012 or D365FO?

Asking because you ended up in the 'old' AX2012 forum.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report
Several approaches are possible. I would use System.String::Format():

str s = System.String::Format('#{0:00000000000.00}', 341.75);

Was this reply helpful? Yes No
baduru hameed 115 on at

Like (0)

Report

Hi Ludwig,

Thanks for your response

I am working in D365 FO

Was this reply helpful? Yes No
baduru hameed 115 on at

Like (0)

Report

Hi Martin,

Thanks for your response

I tried the above code but it's not working as expected for my data entity export activity

str customerBalance = System.String::Format('#{0:00000000000.00}', custTrans.AmountMST);

Actual o/p:

#000000003

Expected o/p:

#00000000341.75

Kindly let me know how can i achieve this format.

Thanks in advance

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Aren't you assigning it to a string variable with StringSize=10? It sounds very likely to me - I guess you're using an EDT with limited string size. after assigning

By the way, I moved this thread to Dynamics 365 Finance forum.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 449 Super User 2025 Season 2

#2

Martin Dráb 422 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans