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
[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
when [RSV_CAT] = "1PDP"
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
Thanks in advance