Sum of average in Spotfire calculated column

Question

I am averaging a calculated column to show on a visualisation but my results are not what I want.

Exploration wells   Discoveries made
0.10                   0
0.87                   0.32
0.51                   0
0.35                   0
0.51                   0

I am calculating the success rate using a simple expression

[Discoveries made] / [Exploration Wells]

But when I use the Avg aggregate in the visual Spotfire averages the Expression row by row rather than taking the average of the sum (for each year lets say)

So instead of getting 13.5% I get 7.4% Is there a workaround for this one?

Thanks.

Here's my summary table

I am looking to get the division of the sums for[Discoveries (net)] and [Exploration Wells (net), which for this year would be 2.65/7.71=0.34

Instead I am getting 0.29

My raw data table looks like that:

That's because Spotfire calculates the division on a row by row basis and provides me with the Avg of the calculated column (0.29)

Any ideas?

Thanks

Answer 1

@Mourst- I calculated success rate which is [Discoveries] / [Exploration Wells] with the raw data provided. I am getting 0.34.

Not sure as why you are getting 0.29. Could you post more details as how you are calculating?

Here are the output tables: