to_number not working as expected
Code is below. I'm outputting all 3 fields individually. The first is 1, the second and third are both zero.
When I add a new column with the definition below, I get a value of zero but I am expecting a value of 1
Any reason why?
to_number(Uniform$Orders.order_dispatched_quantity) - to_number(Uniform$Orders.missing_quantity) - to_number(Uniform$Orders.received_quantity)