Forum Discussion
adhumal2
3 years agoHelper III
Subtraction in metrix table columns
Hi friends,
I have created a metrics table as per the image. I want to now show the difference between 2 columns i.e. M and F. The difference is the subtraction of column F from Column M. How to do it?
4 Replies
- Mahesh0016Super User
adhumal2 I hope this helps you!Thank You!!
subtract = Measure[M]-Measure[F]- adhumal2Helper III
Mahesh0016 Hi Mahesh, Its one measure separated by column 'gender'. There are no separate measures
- Mahesh0016Super User
Subtract=
Var F=Calculate(measure, gender ="F")
Var M=Calculate(measure, gender ="M")
Return
M-F
adhumal2 Please try this
- Mahesh0016Super User
adhumal2 can you please share your exact output in table.