Removing Decimal Places in CONCATENATE() Function


#1

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


#2

@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é


#3

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.


#4

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?


#5

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 :slight_smile: