Dynamically selecting column

[Meenssankar]

Hi,

I have been working on workflow which is having column from Jan to Dec. I need to pickup current month. For instance , if current month is July it should pickup only July values. 

Column name will be like SUMOFCY01,SUMOFCY02...till SUMOFCY12. If it is JUly, then it should pick up 'SUMOFCY07'

Thanks

[atcodedog05]

Hi @Meenssankar 

You can use dynamic select like below. Since the current month is 08 it's selecting column name ending with 08.

Workflow:

Hope this helps : )

[Meenssankar]

That really helps! However, It should select previous month like if it is AUG , it should be JUly SUMOFCY07. Also, same data set also having SUMOFPY01,SUMofPY02...In this case, it will give both SUMOFPY08,SUMOFCY08. But I need CY08 only.

 Fields :

Banker ProductCategory SumOfPY01 SumOfPY02 SumOfPY03 SumOfPY04 SumOfPY05 SumOfPY06 SumOfPY07 SumOfPY08 SumOfPY09 SumOfPY10 SumOfPY11 SumOfPY12 SumOfCY01 SumOfCY02 SumOfCY03 SumOfCY04 SumOfCY05 SumOfCY06 SumOfCY07 SumOfCY08 SumOfCY09 SumOfCY10 SumOfCY11 SumOfCY12 Segment Sales_Region

[Meenssankar]

Right([Name], 2) =
Padleft(Tostring(DateTimeMonth(DateTimeNow())-1),2,"0") 

I used the above one and I am getting previous month data. However, there is a prefix 'SUMOFCY' . How to add that in the formulae.

[atcodedog05 · Accepted solution]

Hi @Meenssankar 

Update formula like below.

Right([Name], 2) =
Padleft(Tostring(DateTimeMonth(DateTimeNow())-1),2,"0") 

and

Contains([Name],"CY")

Workflow:

Hope this helps : )

[Meenssankar]

That's so quick and works well. Many Thanks.

[atcodedog05]

Happy to help : ) @Meenssankar 

Cheers and have a nice day!