Skip to main content

Hi all,



I’m using the following CONCATENATE() function inside of a SWITCH() which is displaying the result below. Is there a way to remove the decimal places so that it’s only correct to two?





CONCATENATE("4 tins: ",“£”,6*26.32)


=


4 tins: £157.92000000000002



@tom_pandsmarine,



My first thought is this: is the calculation “6*26.32” based on a field in your table? If so, than it would be a lot easier to refer to that field in the CONCATENATE formula.



Regards,


André

Thanks for the replay @Andre_Zijlstra.



No, the figure on the right of the multiplication is a lookup field from another table. I’ve changed it here for clarity.

Thank you @tom_pandsmarine.



So, to make sure I understand it the right way: In the formula you refer to a field, and then it renders a figure you showed in the first post?

Thank you @tom_pandsmarine.



So, to make sure I understand it the right way: In the formula you refer to a field, and then it renders a figure you showed in the first post?


That’s right @Andre_Zijlstra.



I’ve just found a workaround by using the ROUND() funtion:





CONCATENATE("4 tins: ",“£”, ROUND(6*26.32,2,0))


=


4 tins: £157.92





It going to end up being a messy formula but it works 🙂

Reply


Terms & Conditions