Calculated Column

[Katie Sikorski]

I am still learning Calculated Columns in Spotfire. I Need to create 3 Calculated columns,

If(RSV_CAT, "1PDP') SUM(GAS/6) +SUM(OIL) for 1PDP Wells only by Outdate as PDP_BOE

If(RSV_CAT, "2PDNP') SUM(GAS/6) + SUM(OIL) for 1PDP + 2PDNP wells only by OUTDATE as PDNP_BOE

If(RSV_CAT, "3PUD") SUM(GAS/6) + SUM(OIL) FOR 1PDP+2PDNP+3PUD wells only by OUTDATE as PUD_BOE.

Hopefully this makes sense as I can't seem to get the logic right.

So I have one table that has a RSV_CAT that has either 1PDP, 2PDNP or 3PUD in it. I only want 3 calculated columns 1 for only PDP Gas/6 + Oil, 1 for PDP +PDNP Gas/6 + Oil and 1 PDP + PDNP + PUD Gas/6+Oil all by date.

[Kirsten Smith (she/her)]

If you can attach a sample of your table it will be easier to suggest expressions.

[Katie Sikorski]

I attached it, it's a huge table. This is Delaware Basin wells.

[Katie Sikorski]

I can get Case to work usingcase

when [RSV_CAT] = "1PDP"

then ([GAS]/6)+[OIL]

else 0 end

However,

I need a Sum by Date By RSV_Cat BOE. So there will only be PDP Boe until 1/2021. Then I need it to add PDP Boe to PDNP BOE as PDP_PDNP_BOE

case

when [RSV_CAT] = "1PDP" AND [RSV_CAT] = "2PDNP"

then ([GAS]/6)+[OIL]

else 0 end

This works But it needs to sum PDP + PDNP Boe and still having trouble making it work.

[Katie Sikorski]

I figured this out so I closed the case