Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

number format to use 9 characters like 000040.00

I have created a formula in a field to display YTD Salary in 9 character fixed width format like 001403.72 instead of 1403.72

It works fine on other fields and I am getting the desired result, but on YTDSalary field, on using the same formula I get the desired format in some records but in some records I get it as 01,403.72

see attached screenshot.

YTDSalary.png (3499 B)
Tags:
Former Member
replied

Hi Parag,

It also considers the thousands separator.

Try this code:

totext(YTDSalary_field,'000000000.00')

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question