Data Analytics

[ayadav8]

Hey!

I have two similar files which contains same monthly columns only separated by 'CM' (current month) & 'PM'(previous month). I want to create two new columns which gives me the difference between the respective months and percentage increase in number. Check the attached screenshot.

Example:

[Diff 2017-11-01] = [CM2017-11-01] - [PM2017-11-01]

[% change 2017-11-01] = [Diff 2017-11-01] / [PM2017-11-01]

I want the tool to dynamically select the required columns for above formula as every month the dates will change. Moreover the name of the new columns should also change dynamically.

Any help here is appreciated! Thanks.

[MSalvage · Accepted solution]

Hi ayadav8,

I have attached a workflow that I think will get you started.

Thanks,

Michael

[ayadav8]

Thank you @MSalvage. Logic works

[nehatimothy]

Hey

I also have the same issue and got the solution for the Data Analytics columns.