Forecast Area Chart

[Katie Sikorski]

I am trying to make an area plot that sums up BOE ((Gas)/6)+ OIL for 1PDP, 2PDNP and 3PUD. I tried this using case but it is not working not sure what I am doing wrong

case

when [RSV_CAT]="1PDP"

[GROSS_GAS] / 6) + [GROSS_OIL]

else 0 end

But the value it is giving me is not correct not sure what spotfire is doing.

Then I tried this, but I am still getting too much

case

when [RSV_CAT] = "1PDP"

then Sum([GROSS_GAS]/6)+Sum([GROSS_OIL])

else 0 end

Nothing I have tried is working right I have Date, RSV_CAT, Gas, Oil and BOE in the table. I just want a calculated column that adds up all the PDP Boe by Date and makes a PDP_BOE calculated column. Then I want it to take by Date and addPDP + PDNP boeand create a calculated column called PDP_PDNP_Boe and lastly, then I want it to take by Date if there is a PDP + PDNP + PUDand create a calculated column called PDP_PDNP_PUD_Boe. I have attached the original data tab. Any help would be appreciate I have been working on this for days and thought I had it on my own but the numbers are not adding up to what I get I calculcate it in excel or access. So for example

 

 

 

DATA

 

BOE DATA

 

RESULTS

 

 

OUTDATE

RSV_CAT

Gas

Oil

 

DATE

PDP_BOE

PDNP_BOE

PUD_BOE

 

DATE

PDP_BOE_CALC

 

PDNP+PDP_CALC

 

PDP+PDNP+PUD_CALC

 

 

1/31/2021

1PDP

71611679

16066472

 

1/31/2021

28001752

1212782

469794

 

1/31/2021

78299

 

29214533.83

 

29684327.83

 

 

1/31/2021

2PDNP

1718388

926384

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1/31/2021

3PUD

702312

352742

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks in advance

[Shrutika Aggarwal]

To Calculate PDP_BOSE,please test usingthe following expression:

Sum(case when [RSV_CAT]="1PDP" THEN ([GROSS_GAS] / 6) + [GROSS_OIL] ELSE 0 END)

OVER (Intersect([OUTDATE],[RSV_CAT]))