Hi All,
I'm struggling to get my head around the following and I hope someone can help.
Here's an example of what's happening:
<tbody>
</tbody>
I have created the following SUMX formula to calculate the ABS Diff., iterating through each row at a time:
The row values returned are correct (in as much as they're the absolute difference between Forecast and Sales), but the total isn't correct and is a sum of the positive and negative values, i.e. it hasn't summed up the absolute values.
What have I done wrong?
Cheers,
Matty
I'm struggling to get my head around the following and I hope someone can help.
Here's an example of what's happening:
Product | Forecast | Sales | Diff. | ABS Diff. |
A | 100 | 95 | 5 | 5 |
B | 150 | 135 | 15 | 15 |
C | 100 | 110 | -10 | 10 |
D | 50 | 75 | -25 | 25 |
E | 50 | 10 | 40 | 40 |
Total | 450 | 425 | 25 | 25 |
<tbody>
</tbody>
I have created the following SUMX formula to calculate the ABS Diff., iterating through each row at a time:
Code:
ABS Diff. = ABS(SUMX(Table,Table[Forecast]-Table[Sales]))
The row values returned are correct (in as much as they're the absolute difference between Forecast and Sales), but the total isn't correct and is a sum of the positive and negative values, i.e. it hasn't summed up the absolute values.
What have I done wrong?
Cheers,
Matty