I am using 2 fields on the Initiative issue type:
- ‘Original Story Points’ to capture the original estimate
- ‘Story Points’ to capture a later, revised estimate
I have built a report that lists the Initiatives in a table column A, with original story points in column B and story points in column C. I want to add a column D that calculates the ‘delta’ between B and C. It could be a positive or negative number. Also, in some cases, B or C or both will be blank, in which case I don’t want any value in D. I only want to show a value in D (for the delta) when both B and C are not empty.
I tried to use coalesce empty but that stripped a bunch of Initiatives off of the results, which is not what I want.
How can I do this? See my screenshot.