Forum Discussion

GerryL's avatar
GerryL
Frequent Visitor
4 years ago

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...
Need Help
GerryL's avatar
GerryL
Frequent Visitor
4 years ago

Yes. Based on what would be there for the range between the From and To columns. I had to break the year (first 4 digits in From and To columns) from the term (last 2 digits) do handle them separately with the plan being to put it back together. Years are easy, but the logic for the term is what is getting me stuck.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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's avatar
    GerryL
    Frequent Visitor
    4 years ago

    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).