Calculating with rows of data dynamically

[TS-User]

Hi! I have a simple gross margin calculation  as set out below (i.e. Gross profit divided by sales). I would use a multi row formula to calculate it, but sometimes I have several months or even weeks of data presented in fields, which would mean that I have to write down a formula for each period separately. Is there a way to make it more dynamic? e.g. determine how many periods there are and then calculate a period specific gross margin at once?

Thanks a lot!

Problem:					Desired outcome
Name	2015	2016	2017		Name	2015	2016	2017
Sales	100	50	20		Sales	100	50	20
Gross profit	30	30	5		Gross profit	30	30	5
					Gross margin	0.3	0.6	0.25

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[TS-User]

thanks! this works great