dynamic avg

[BosKev]

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

[JosephSerpis]

Hi @BosKev I mocked up a workflow using a summarize tool rather than multi row tool. Let me know what you think?

[BosKev]

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?

 

[JosephSerpis · Accepted solution]

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. 

[BosKev]

Thanks, that was easy!