Suppress leading zero for a decimal number

SAP Support Note 1212998 - Covers this.  But you have to download a UFL.
Here's my adaptation -

Put this in the DECIMALS Formula

Set the ROUNDING to the Max positions you want to show.
Example if you want 2 decimal places max set Rounding to 0.01

-Doug

//Number Formatting Formula to Eliminate Trailing Zeros.
//Put this in the DECIMALS Formula
//Set the ROUNDING to the Max positions you want to show.
//Example if you want 2 decimal places max set Rounding to 0.01
 
//SAP Support Note 1212998 - Covers this.  But you have to download a UFL.
//Here's my adaptation -
 
local StringVar array a := Split (ToText(CurrentFieldValue),".");
local stringvar s := Trim(a[2]);
local numbervar result;
local numbervar x;
 
for x := len(s) to 1 step -1 do
(
    if s[x]<> "0" then (
        result:=x;
        exit for;
    );
);
result

Select allOpen in new window

Thanks, it works.