asked on

FM - Can You Get a Range of Values, Not Just one Value?

Have a "YearWeek" table that summarizes "Leads" data by Week in several different fields. Created a list field that pulls together all the fields in the YearWeek table and then in the main "Leads" table's script used the List function to list all the records going back a year. However, now boss only wants to go back 4 months. Can I do that with the GetValue function? Looked it up, but it doesn't seem to accept an arugment for range of values. How would you do it?

ASKER CERTIFIED SOLUTION

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rvfowler2

ASKER

Thanks, Will. I ended up creating a new T.O. so as not to affect the existing T.O. Link and just linked the YrMon4MonsAgo to YearMonth via a calc field as you suggest above and it worked fine. Too bad that don't have a range of GetValues.

Will Loving

There are ways to do that include custom functions but you would still need a way do determine which record to start with four months ago. That's probably easier done just using the relationship.

rvfowler2

ASKER

I was thinking of a GetRecordCount then a value range that is subtracted from that such as 246 (# of records representing # of weeks in the table) - 17 ( the amount of weeks my boss wants me to go back). Just looking more for ways to save T.O.s as my Relationships graph is getting busy, even organizing it into clusters.