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
You don't need to repeat year([Date]) multiple times.
A simple
Case(Year([Date]),
2015,result 1,
2016, result 2,
2017, result 3,
....)
A simple
Case(Year([Date]),
2015,result 1,
2016, result 2,
2017, result 3,
....)