Forum Discussion
Solved
Sum vs multiplication
Hi,
my table is warking badly.
Thank you
Ondřej
If Trips is sum or a number column
Sumx(Table, Table[trips]*Table[Distance round])
Or if you want multiplication after agg then do at a level
sumx(summarize(Table,Table[Kod Dp..],"_1",Sum(Table[Distance round]),"_2",[Trips]),[_1]*[_2])
Taking a group level for correct multiplication
2 Replies
If Trips is sum or a number column
Sumx(Table, Table[trips]*Table[Distance round])
Or if you want multiplication after agg then do at a level
sumx(summarize(Table,Table[Kod Dp..],"_1",Sum(Table[Distance round]),"_2",[Trips]),[_1]*[_2])
Taking a group level for correct multiplication
