Total column calculation

calculatedmembers

#1

We have a new calculated measure called ‘Base capacity’ and it’s a default number 67 & this number changes all the time.

We didn’t add any code, just a number 67.

Now 67 in each row is calculated against the second column ‘Story Points created’ and the result is displayed in the fourth column ‘Capacity Avl’.

When we use show totals of rows, everything looks ok except this 67, the total of this column ‘base capacity’ displays as 67. it’s not adding all 67’s instead, it just displays 67.

Base capacity is the user-defined calculated member

Please look at the attachment123


How to calculate Story points of all issues with custom field option X in given epic