This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
If the last few digits in a numeric field is zero, I would like to hide that zero. And I would like to implement it with a numeric field, not a character field. I've tried a few editing options and it seems that decimal zeros are always visible.
I did the following test.
as you want to handle that as a number, I cannot find an edit code or edit word that can do the trick as usually one of the goals with numbers is to get then aligned to the right and for that, well you need the same quantity of decimals, hence the extra zeros... your best bet is to present it as a string, the trailing zeros will be removed when you use for example AsDisplayString with BareString_M . If you really want to have the column numeric, you can add a second column with the string, and make the first one with the number not visible.
Thank you so much for replying to this question.
I will consider to use string fields on the screen. Also, I could learn how to use the AsDisplayString method.
Thank you for your support!!