Right ( " " & YourNumberField ; 20 )
There are 20 space characters between the quotation marks.
dude, you are a genius! :)
i was trying nearly every function but could not get it with my poor logic and experience in fm within one hour.
in many cases, the leading spaces will not be needed. In many cases, you can simply select a right alignment (justification) as a format for the field in a layout. In other cases, where the data must be combined with other data in the same field, a tab can be used and the inspector can be used to set a right aligned tab stop for this data.