Multi row formula logic

[stj1120]

Hi there,

I need to do the difference of the values present in each week for each material with respect to each country and show the result in the Delta row of each week. I tried using Multi row formula but, it is not working as expected. 

Below is the highlighted area where I'm unable to get the right logic in multi row formula tool in Delta row. 

Could anyone help me with the right logic here?

expected output should be like below. 

Please check the attached workflow.

Thank you.

Best regards,

Tj.

[Prometheus]

@stj1120 Try deselecting "YYMMMM" from Group By in the Multi-Row Formula tool.

[stj1120]

Hi @Prometheus 

Thank you for helping me.

If I deselect YYMMMM then I'm not getting the actual U3 values for the relevant weeks. It should be selected in group by tab of multi row formula tool. 

Below image shows incorrect U3 values when deselected YYMMMM in group by.

Below image showing the correct U3 values when YYMMMM is selected in group by.

Showing Correct values for the relevant weeks when YYMMMM is selected

I selected YYMMMM in Multi row formula tool. But, no luck. Please check and help with the right logic. 

[Prometheus · Accepted solution]

@stj1120 From what I understand in your logic, GSF310 is like what's in your inventory and LAUNCH ORDER and Resupply Order are subtracted from it to get your delta (New Field). I used the Cross Tab tool to move these out to their own fields then replaced nulls with zeroes and did the math. Please let me know if this works for you.