Return to FileMaker.com
Calculation formula: depreciation per year
I'm trying to create a formula for calculating the depreciation per year for inventory and I wrote the formula:
(Unit Cost - Value at the end of Life) /Life Span
All those fields are created with numbers in them and the depreciation per year field is given me a "?" for answer.
Anybody knows how to make this work?
Your syntax is correct. Sure you don't have a zero or no value in Life Span? Divide by zero will produce a question mark result.
Retrieving data ...