1 of 1 people found this helpful
see the attached - there are 2 approaches
one uses lookup the other uses LOD's
the Lookup looks like this
and returns this
the LOD avoids the need for a table
this is the intro date
and this assigns the label
and it can return this (not table necessary)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Jim, Wow thanks for the help. It looks like I was over complicating my LOD and tried to make it as one LOD but breaking it out into three as you did it works perfectly.
I havent tried the LOOKUP as I wouldn't need a table. Thanks!
Glad to help out
I have an engineering degree so breaking it into 3 calculations comes naturally but also it is a little more efficient to separate them out - especially when working with large data sets