Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of fields called Month01, Month02, Month03, etc... I'm trying to return the value of Month## dynamically by using another field value, CurveStartMonth, to indicate the month numbers. So, if the value of CurveStartMonth is 5, then 'Month' & Num(CurveStartMonth,'00') returns the desired text in the expression field, Month05, but I need the value of Month05 to be returned. How can this be done? Thanks!
I've now included CurveStartMonth as part of the load script, so now it is a data field rather than expression, but I'm still not having any luck. I'm thinking it's just not doable. I'll work on getting the data laid out in way to achieve my goal.
Thanks