Forum Discussion
Multiply 2 columns from 2 different data tables
Help me! I have 2 data tables link with look_up table throug Field PID: Table 1 [PID, Balance] link with Look_up table[PID]: relation n*1 Table 2 [PID, RATE] link with Look_up table [PID]: rel...
=sumx(relatedtable(table1),sumx(relatedtable(table2),table1[Balance]*table2[rate]))
=sumx(relatedtable(table1),sumx(relatedtable(table2),table1[Balance]*table2[rate]))
Awesome, it works.
But could you help me to understand more about the logic here.
Function SUMX: SUMX(Table, Expression)
- Table: Table in which the expression will be evaluated
- Expression: Expression to be evaluated for each row of the given table