Fixed decimal precission

Question

Hello everyone

I have an excel input with 2 fields. These 2 fields has exactly same values however

value1 is in custom format ( _(* #,##0.00000000_);_(* (#,##0.00000000);_(* "-"??_);_(@_))

and Value 2 is in number format with 10 decimals.

I used Select tool to change format of both fields and used, 19.8, 19.9 and 19.10.

Strangely result deletes field values and brings null value for 19.10.

Any idea why this is happening?

Thank you in advance

MOHAMMEDAFZAL · Accepted Answer

Hey @slckkrky

I think i got the reason why 19.10 is giving Null results.

The number of characters in "" is 17 (including '-' and '.') and when you give the FD length 19.8 the total characters become 18 (as a '0' gets added at the end. Similarly when you give the FD length 19.9 the total characters become 19 (as two zeroes gets added at the end) which still satisfies the FD length condition.

But when you give 19.10 then it breaches the total length as the number of characters become 20. Hence it results in Null.

Try using 20.10 then it will work.

Hopefully this answers your query. 🙂

Find attached WF