Forum Discussion
dshah12
Helper II
2 years agoI have a 2 columns and do difference
| Appl no | sum of fore | recomm |
| 1 | 100 | 126 |
| 2 | 200 | 200 |
I want to do the difference of the sum of fore - recomm, but i don't want that it sums the recomm
I tried calculated column but it does not work
Help appreaciated !
Thank you
3 Replies
- vojtechsima
Super User
Hi, dshah12 ,
bit confusing, but do you want it like this?
Measure:
Total Difference = SUMX('Table', 'Table'[sum of fore] - 'Table'[recomm])- dshah12
Helper II
Hi thank for the reply but this formula will sum the recomm amount I don't want that it should be without that
- vojtechsima
Super User
dshah12 but how do you wanna they display it, you can see that if you put to each line, it's not a sum, but it i a individual level.
Do you want it as calculated column then, or could you give me please example of the result?