Hello, I’m performing this calculation but I’m having issues with the multiplication and data aggregation. When I perform the calculation without using SUM in front of each variable, the values appear as zero in the rows of the column. However, if I use SUM in front of each variable, the row values are calculated correctly, but the total at the bottom is completely incorrect — as shown in the attached screenshots.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |