Populating Attributes from Elements

[LanceColins]

Hello,

I would like to be able to populate an attribute based on a list elements and be able to update this each month.

Scenario:
I would like to be able to capture all active projects so I created an element called "Active Projects Text". This measure is a String and is populated with either "active" or "non-active" based on a Rule.

I created a TI process which has included parameters (vmonth,vyears) to capture the specific month and year, which can updated each month using an action button.

Within the TI Rule below the "vClient_Project" is the list of projects I would like to retrieve from and update the attribute in this dimension.

the rest of the variables are static to capture the data.

CellGetS('Project Forecast',vClient_Project,'Actual','CAD($)','Total Contractor-Employee',vmonth,vyears,'Active Project Text');

AttrPutS ('Active','Client-Project',vClient_Project,'Active Projects');

Lastly, when I change "vClient-Project" to a specific project it populates the attribute field, but doesn't work when I want to select the whole variable .

Hopefully that makes sense?

Thanks
Lance