The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Combine 2 calculations to create one field

Topic Labels: Formulas
Solved
1044 4
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I am creating an asset register with the current values of assets. I have two formula columns in use to output the current data.

Wondering if I can combine/nest the two formulas into one?

This is what I have now, any advice on how I would combine these into one forumla?

Top row is one column, bottom is the final row with current value.

``````(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})

MAX(SUM(Price-{Depreciation}),0)``````

1 Solution

Accepted Solutions
11 - Venus

If the first line is depreciation, it would look like this.

``MAX(SUM(Price-(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})),0)``
4 Replies 4
11 - Venus

You mean like this?

``````(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})
& "\n\n" &
MAX(SUM(Price-{Depreciation}),0)``````

"\n" is the symbol for a new line.

6 - Interface Innovator

I did try this, but it then gives me the two answers in the same column.

I am looking for the column to only show the current price. So the first line works out the amount the product has depreciated, and the next line works out the current value.
They are two separate columns, and I was wondering if I can combine the formula in to one column somehow.

11 - Venus

If the first line is depreciation, it would look like this.

``MAX(SUM(Price-(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})),0)``
6 - Interface Innovator

Excellent! Thank you that worked! I just couldn't work out how to put it in to one calculation and it was annoying me having to hide one column rather than just doing it all in one 🙂