I have two number fields which I need to concatenate and I want to do this via a formula.
It needs to work thus: <number 1>.<number 2>
However, when I make a formula to do this it puts 2 decimal places at the end of each number so I end up with something like this "99.00.3,499.00" when I really want "99.3499". (Incidentally, I also want to remove the "," separator in 3,499).
I tried "truncate(<number1>) & "." & truncate(<number2>) but it failed to strip the decimal places like it says in the documentation. I've tried also "int" and "round" but also to no effect.
How do I rid myself off these decimal places?
It needs to work thus: <number 1>.<number 2>
However, when I make a formula to do this it puts 2 decimal places at the end of each number so I end up with something like this "99.00.3,499.00" when I really want "99.3499". (Incidentally, I also want to remove the "," separator in 3,499).
I tried "truncate(<number1>) & "." & truncate(<number2>) but it failed to strip the decimal places like it says in the documentation. I've tried also "int" and "round" but also to no effect.
How do I rid myself off these decimal places?