Hi all,
I have an problem with FMT function. I have requirement where i have to do RIGHT ALIGN Space fill for decimal field.
eg:- Quantity- decimal(17,4) is the input given
OutPut:- < 645.0000>
So to do right align space fill i wrote the below derivation for quantity filed as
FMT(Quantity, "17' 'R").
But the does not works out its failng.
Please correct me if anything is missing
Fmt function for decimal data type
Moderators: chulett, rschirm, roy
The FMT(x,"17' 'R") statement will do what you stated you want done. Could you post your source data and the failed result of the format so that we could understand what didn't work?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>