Dec 23, 2022 06:58 AM
The field entries are £20.49 and £13.66 (both fields set to 2 decimal places) but in a third field when I use CONCATENATE this is what I get:
Summary: Headline £15000 pa Actual £9975 pa £20.491666666666667 £13.661111111111111
How do I get £20.49 and £13.66 ?
tia
ps - I daresay this (sort of) question has been asked before but I have no idea what to search for.
Solved! Go to Solution.
Dec 28, 2022 02:10 AM
Thank you. I am familiar with ROUND, having used it for calculations in a Fielemaker database.
Frankly I was hoping to be provided with the answer on a plate rather than having to work it out for myself. Telling me about ROUND was very helpful, thank you, but I was still at a loss over what to do. However, I have persevered and am pleased to say the following works:
CONCATENATE(Description, " ", ROUND({Total sqft}, 2), " ","at"," ","A/", R, " ", "= ", ROUND({enter sum ITZA sqft}, 2), " ", "sqft")
Screenshot:
Dec 23, 2022 10:06 AM
Can you provide more information? What are the 3 field types (text, currency etc). Also show the third fields calculation.
Concatinate joins two text fields together so if I read it right you are trying to join "15000" to "9975" to make "150009975". This seems a bit odd.
Dec 23, 2022 10:04 PM
Perhaps try utilizing `ROUND(value, precision)` with your formula?
Dec 27, 2022 10:02 AM
Round might be the solution, thank you but to enable me to try it please let me know how i should use it for 2 decimal places in the following formula?
Dec 27, 2022 10:12 AM
The extra decimal places appear because you have the original formula fields set to display two decimal places, but the additional decimal places are still calculated and stored in the field values. Adam is correct in that you should use ROUND(). It is documented in the Formula Field Reference. I also recommend using ROUND() in your original formulas {Total sqft} and {enter sum ITZA sqft} versus in the CONCATENATE() formula.
Dec 27, 2022 10:38 AM
Apologies but i still do not understand.
Dec 27, 2022 10:39 AM
Sorry about the spelling mistakes, nowhere to edit after posting!
Dec 27, 2022 11:20 PM
Dec 28, 2022 02:10 AM
Thank you. I am familiar with ROUND, having used it for calculations in a Fielemaker database.
Frankly I was hoping to be provided with the answer on a plate rather than having to work it out for myself. Telling me about ROUND was very helpful, thank you, but I was still at a loss over what to do. However, I have persevered and am pleased to say the following works:
CONCATENATE(Description, " ", ROUND({Total sqft}, 2), " ","at"," ","A/", R, " ", "= ", ROUND({enter sum ITZA sqft}, 2), " ", "sqft")
Screenshot: