Multi Row Tool

Question

hi- I ran into an issue that my Multi Row formula doesn't work correctly the way I want it if im missing weeks in between. As shown below, Its missing week 7 and 8 so my Multi row automatically picks up week 3 and 4 instead ( so 6 rows total) .My calculation is that calculate average of 5 weeks before and current  to get the current week new Cost . What is the best way to fix this? How do i add missing weeks to my formula. Thanks a lot

ShankerV · Answer

Hi @linhtran

Please add the Generate rows tool before the multirow tool and after the sort tool in your workflow.

Also I have update the generate tool from 12 to 52.

Many thanks

Shanker V

Multi Row Tool.yxmd

linhtran · Answer

I have this calculation by Location, Product, and Temp zone level. At the temp level (dry level), its missing week 7 and 8 but other temps have full 52 weeks in a year. Before the multi Row I sorted it by Location,Product,Temp zone, Year, Fiscal Week. Where do I add the Generate Row tool and how do I apply it to make the weeks that missing in a specfic Temp zone appear with 0 values. Appreciate your help.

ShankerV · Answer

Hi @linhtran

Please find the sample use case for your scenario where you can apply the 5 month average logic at the end of Multi row formula tool.

Many thanks

Shanker V

Multi Row Tool.yxmd