Forum Discussion
How to calculate difference between two columns - related column and count column
I'm struggling with this. I want to create a column that calculates the difference of (First RequiredShiftA) and (CountDuringShiftA) columns. This started as two tables. I created new columns i...
For example, using that formula:
instead of 2 - 2 = 0
I am getting -6
So I'm not exactly sure what is being calculated
ibarrau
Super User
Super UserAre you sure you are checking the result in the data view?
2 - 2 = 6 sounds like having the visualization with a value of SUM of calculatedColumn.
Can you show a picture with the two columns and the substract result from the DataView?
The one column was a quick measure and doesn't show up in the data view.
- ibarrau
Then don't use a "quick measure" and create a "calculated column" with the substract.
I've been trying. I get a lot of errors.