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
Are you using a fixed decimal datatype? If so, Alteryx will be forced to show at this level. Unless you're needing this level of detail, you could change it to a double? If you're wanting to replace nulls with 0, could you not just use the data cleanse tool? Does that have the same effect?
You could also do something like this. This maintains just being 0 if you then change it back to a number (FixedDecimal included) with a select tool afterwards:
Hi! Thank you for your reply. Yes, I need fixed decimal datatype. Data cleanse tool has the same behaviour, I initially used it.
Best regards,
Oksana
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
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!
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