3070_en-US

liliconcom

How to make Summary(Group) read in an array of columns?Hi, how to make a for loop list the statistic columns in Summary(Group) instead of writing out every one (as in my case the FruitType list may actually change)... thx, dj

FruitType={};
FruitType={"Apple", "Orange", "Banana"}; //list of fruit columns showing weights of each fruit
FruitTypeN=N Items(FruitType);

//Summarize the average of each fruit type
Summary(
Group(:Fruit,
For(t=1,t=Mean(parse(eval(":" || FruitType))),
),
Output Table Name("Fruit Type Average"));

Message was edited by: djhanson