Forum Discussion
Helper IThe visual is exceeding available resources
Hi kzielinska ,
Since you are doing a SUMX, this is getting all the lines of the table and making a row by row calculation,
Why are you using a SUMX to make this interaction? Can't you use a simple sum?
The formula you are using is first group the documents, adding a line per each net value and then summing them up what happens in your calculation is the following;
Document Net Value A 10 A 10 A 20 B 15 TOTAL 55 SUMX is doing:
Document Net Value A 10 A 20 B 15 TOTAL 45 The final value you want is the 45?
Super UserHi kzielinska ,
Since you are doing a SUMX, this is getting all the lines of the table and making a row by row calculation,
Why are you using a SUMX to make this interaction? Can't you use a simple sum?
The formula you are using is first group the documents, adding a line per each net value and then summing them up what happens in your calculation is the following;
| Document | Net Value |
| A | 10 |
| A | 10 |
| A | 20 |
| B | 15 |
| TOTAL | 55 |
SUMX is doing:
| Document | Net Value |
| A | 10 |
| A | 20 |
| B | 15 |
| TOTAL | 45 |
The final value you want is the 45?