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 NAMESum_2019_01_31Sum_2019_02_28Sum_2019_03_31Sum_2019_04_30AvgA01000.25B01200.75C1521271419.25D1419222820.75Total2942514241 Dynamic_Avg_Test.yxmd

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

dynamic avg

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

Dynamic_Avg_Test.yxmd

Help

Expression

Accepted answers

JosephSerpis

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.

Dynamic_Avg_Test_160919.yxmd

All comments

JosephSerpis

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

Dynamic_Avg_Test_160919.yxmd

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?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335