Forum Discussion
GerryL
4 years agoFrequent Visitor
List.Numbers Within a Range
Hello, I'm trying to generate a list of numbers in my dataset within a range from 10-50 in an increment of 10. In other words, as it generates the number for each row, when it gets to 50, it shou...
Vijay_A_Verma
4 years agoMost Valuable Professional
I notice that for 2012, you have generated 50.
For 2013 - 10, 20
For 2014 - 30, 40, 50
What is the logic behind this?
(These numbers I am reading from last column which is named as Term Codes)
GerryL
4 years agoFrequent Visitor
Hi,
201250 is the first one, based on the fact that it exists in the From for that program. So 50 is the starting point and is broken out into the From Term column. For each year on that same program, I have to generate the terms (from 10 to 50) starting with the first one (in the example it starts with 50 in the year 2012. So it would go 201250, 201310, 201320. . . 201410, 201420, etc. until it gets to 2022320 (the To column).