I am attempting to calculate asset depreciation using Airtable. I am calculating using the following Fields:

**Purchase Date**: Date field

**Unrecovered Basis 1**: A formula which is returning a currency value

**1 Year (from Depreciation Conventions)**: This is a lookup to another table which has the 1 year depreciation amount. This is a numerical value (decimal)

I have reduced the formula I am attempting to use down to it’s simplest form. There will be more switch states, but it doesn’t even work with the 1, so I didn’t want to confuse matters by adding more. The formula returns a result just fine, but I am unable to format it as a number (currency) and thus, am unable to use the value in future formulas.

The Formula is this:

SWITCH(DATETIME_FORMAT({Purchase Date}, ‘YYYY’) - 2015,1,{Unrecovered Basis 1}*{1 Year (from Depreciation Conventions)},BLANK())

When attempting to format the field, it states “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.”

If I put the exact same formula outside the switch statement, it works. Does switch not return numbers by default? What can I do to make it do so?

Thanks!