Urgent help required for converting months in columns with numeric values to aggregating

surendrasharma880

Hi Community members,

I have a situation where I need a conditional statement  and help as follows

Condition 1

if department = "Electronics" then we need a total current month + 2 month  (Eg: we are in May then the formula shoud detect May and add columns May$ + June$ +July$ ). When we are in June it should add  starting from June.

Condition 2

if deparment = "Groceries" then add current month + 1 month 

We need to use the columns for with Jan $, Feb $ and so on for aggregation. 

Can some one please advise how should we start this and how will the workflow know which is the current month.

Please help. I have attached the excel

Working File.xlsx

deviseetharaman

Hi Surendra,

Please check if this solution works for you.

I have tried getting the current month and used a formula tool for calculation.

You may include/exclude the columns you need using the SELECT tool.

Attached the alteryx workflow.

Please do let me know if it helps!

Month wise amount calculation.yxmd