How to add and subtract two different columns

Question

Hello,

I have two columns generated in the dataset via SQL query that are aggregated and are of datatype integer.

I want to create a another two column in the dataset that is a summation and difference of those two columns via custom or guided formula. Is this possible, how?

For example below -

The query is

List of steps for manipulation

Resultset looks like (where column Name is Sprint Name , query is filtered to show only one sprint as of now)

What i would like to have is

1. Column generated through formula which is difference of columns "Issue closed-added" and "Issue closed-removed"

Thanks

Kevin Minnick · Accepted Answer

Hello, yes this is possible. You need to click "Formula Column", then "Custom Formula" (all the way at the top). From here you can start typing a double quotation mark (") and the name of the column. (It should auto-complete). And then you would type "-" and then the name of the second column. Custom formula allows all kinds of simple math so give it a try!