Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How show a Real Field as Percentage in a Grid?

(0) ShareShare
ReportReport
Posted on by 578

Hello, i like show a Real Field as Percentage, i add Percent EDT to the field (in Table), but keeps showing as real.

My values are 0.10, 0.40, 5.40 .. etc and i like show 0.1%, 0.40% 5.4% ....

Thanks

*This post is locked for comments

  • ismaelivan Profile Picture
    578 on at
    RE: How show a Real Field as Percentage in a Grid?

    Is there no other way ?, then what is the Percent EDT ? I do not want to use code for this form.

  • Suggested answer
    Chaitanya Golla Profile Picture
    17,225 on at
    RE: How show a Real Field as Percentage in a Grid?

    Hi,

    I would suggest to keep the field as real and change the label to something that has suffix % like discount % (or) else you have to save it as a string by appending the real value(using num2str() function) with percentage symbol '%' and for every needed calculation need to extract the integer part from string(using substr() function), convert it to real(using str2num() function), perform calculation, convert real to string(using num2str() function) and append %symbol back again which is clearly an overhead.

  • Suggested answer
    Pradeep Itnal Profile Picture
    3,248 on at
    RE: How show a Real Field as Percentage in a Grid?

    write an edit method , which returns string as 0.40 %, 0.1%. in edit method use  num2str function. u will get ample of examples in AOT on edit methods.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Kempeth Profile Picture

Kempeth 4

#1
Andy Adamak Profile Picture

Andy Adamak 4

#1
Community Member Profile Picture

Community Member 4

Featured topics

Product updates

Dynamics 365 release plans