Multi row formula logic

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.

zxcv.yxmd

Workflow

Transformation

Accepted answers

Prometheus

@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.

Turn Into Cols.PNG

GSF310 minus order.PNG

zxcv v2.yxmd

All comments

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

Turn Into Cols.PNG

GSF310 minus order.PNG

zxcv v2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703