Forecast Area Chart

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 add PDP + PDNP boe and create a calculated column called PDP_PDNP_Boe and lastly, then I want it to take by Date if there is a PDP + PDNP + PUD and 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

Attachments

AttachmentSize
File boe_data.xlsx4.46 MB
Login