case formula returning one value
Newbie here! Probably a silly error on my part but... I am trying to create a formula in the field "Mileage Cost" that will look at a date in the field "Date", find what year "Date" contains, and...
Forum Discussion
Ya, that formula is a bit muddled. You are over complicating it.
Case(Year([Date]),
2015,[Mileage]*0.575,
2016,[Mileage]*0.54,
2017,[Mileage]*0.535,
2018,[Mileage]*0.545,
null)
Case(Year([Date]),
2015,[Mileage]*0.575,
2016,[Mileage]*0.54,
2017,[Mileage]*0.535,
2018,[Mileage]*0.545,
null)