Forum Discussion

JeremyCohen2's avatar
JeremyCohen2
Qrew Trainee
6 years ago

Searching for text in field name within formula ie. 2019, 2018, 2017 in field name

I am trying to make a formula that pulls through historical data to find which one to utilize.  Currently I'm using dates but I can see multiple areas where this is very useful.   In excel it would...
Formulas and functions
Tables and fields
JeremyCohen2's avatar
JeremyCohen2
Qrew Trainee
6 years ago
Maintaining history of years prior while allowing the fluctuation of what field is used in the calculation.  

In this circumstance it is important to keep historical data but the calculation should always be on the current year.  I have other circumstances that are similar where historical data is also important.