Alteryx Desktop: multi-field tool is changing the decimals

Question

Hi,

Could you please advise how to fix the following issue. I am using multi-field formula to replace nulls to 0 and multi-field formula tool ( I also tried cleansing tool, the same behaviour) and after applying this tool decimal values are changed, please see below:

Thank you in advance!

Best regards,

Oksana

HomesickSurfer · Answer

Hi @OksanaBezpyata

Using a select tool just before a data cleanse tool, modify the Sales Value field type tp Fixed Decimal, size 19.10.

Result.

SALES VALUE
2524.5779000000
0.0000000000

DataNath · Answer

You wouldn't need a formula for each, you could just use another multi-field (then select after to change back to FixedDecimal). If it's not a viable option then no problem but can't think of any other options off the top of my head!

OksanaBezpyata · Answer

Yes, as a workaround it may be used, but I would rather not apply it, as I have lots of columns, which this logic would have need to be applied for, it would probably influence the performance.

Thank you a lot for your suggestions.

Best regards,

Oksana