Help

Combine 2 calculations to create one field

Topic Labels: Formulas
Solved
Jump to Solution
1337 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Kel_Asp
6 - Interface Innovator
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
Sho
11 - Venus
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)

See Solution in Thread

4 Replies 4
Sho
11 - Venus
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.

Kel_Asp
6 - Interface Innovator
6 - Interface Innovator

Thanks for your reply @Sho 

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. 

Sho
11 - Venus
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)
Kel_Asp
6 - Interface Innovator
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 🙂