Hi All,
I want to use the multi row tool to create a avg going across each row of a table. I'm having trouble with the conditional statement , was wondering if someone could help. Thanks.
DIVISION NAME | Sum_2019_01_31 | Sum_2019_02_28 | Sum_2019_03_31 | Sum_2019_04_30 | Avg |
A | 0 | 1 | 0 | 0 | 0.25 |
B | 0 | 1 | 2 | 0 | 0.75 |
C | 15 | 21 | 27 | 14 | 19.25 |
D | 14 | 19 | 22 | 28 | 20.75 |
Total | 29 | 42 | 51 | 42 | 41 |
Solved! Go to Solution.
Hi @BosKev I mocked up a workflow using a summarize tool rather than multi row tool. Let me know what you think?
Hi, @JosephSerpis I thought about doing it that way but it won't be able to dynamically select the new periods if its pops up?
Hi @BosKev the way you built it using a transpose will make it dynamic. I added in another period and it didn't error was processed dynamically.
Thanks, that was easy!