How to set number of decimal places

CloverDX Platform
1

Apologies that this is such a stupid question!

Please could someone advise what function to use to set the number of decimal places of a number(long), using the Transform Editor. So I just want to set 1.9993335 to be 1.99

Thanks!

Dave

2

Hi,

I would recommend two options depending if you want to round the decimal value or not:

  • You can change the metadata type from number to decimal (will not round the value), also make sure you specify the precision in property Scale
  • Use a Reformat component and in the CTL code use function round (you can find more information on how round here)