This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Field entries are £20.49 and £13.66 but in a thir...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved

Jump to Solution

0
3727
8

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:

8 Replies 8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 23, 2022 10:06 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 23, 2022 10:04 PM

Perhaps try utilizing `ROUND(value, precision)` with your formula?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?

CONCATENATE(Description, " ", {Total sqft}, " ","at"," ","A/", R, " ", "= ", {enter sum ITZA sqft}," ", "sqft")

Incidentally the above formula works without any problem in most of the rows, as per the screeshots below:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 27, 2022 10:12 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 27, 2022 10:38 AM

Apologies but i still do not understand.

ROUND(Description, " ", {Total sqft},

" ","at"," ","A/", R, " ", "= ", {enter sum ITZA sqft}," ", "sqft", 2)

displays as Error

I am not trying as John B2 suggests 15000" to "9975" to make "150009975" but to display te text in the field 'description', its area in is the field for the area, the fraction for theat area (eg A/1 or A2/) that I have entered in the fraction field and the result which I ahave also entered in a sparat field, per this amended schreenshor:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 27, 2022 10:39 AM

Sorry about the spelling mistakes, nowhere to edit after posting!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dec 27, 2022 11:20 PM

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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: