KB486134: Workstation attribute editor strips trailing zeros from numbers after decimal point

Symptoms

• The attribute form is defined with numbers with trailing zeros, however when we generate the SQL, the trailing zeros are omitted

Steps to Reproduce

• With Strategy Tutorial tables and columns we can reproduce this issue.
• Create a new attribute Year_Duration, and create a new attribute form: 

• Create a report, and add the Year_Duration attribute to the report.
• Execute the report, and view SQL, we can see the 0 in the 1.0 is omitted:

Cause

This is a known behavior in Strategy 2021 and previous versions. The Data Engine is designed to omit the trailing zeros when loading the constant expression. 

Workaround

There is a workaround using ApplySimple for this issue. Instead of defining the attribute form directly, we can use Apply Simple and define the attribute form like this:

When we replace this attribute with the original one, execute the report and view SQL, we can see the SQL contains the trailing zero.