+5I 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)
Best answer by Sho
If the first line is depreciation, it would look like this.
MAX(SUM(Price-(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})),0)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.
+5Thanks 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.
If the first line is depreciation, it would look like this.
MAX(SUM(Price-(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})),0)+5If the first line is depreciation, it would look like this.
MAX(SUM(Price-(DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price})),0)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 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.