How to use multiple sums in Set Analysis

[hansdevr]

Hi Everyone,

I'm working on a dashboard in which a decline/accept percentage on damage claims is calculated.

For one date it's not that hard: sum(Toewijzing) / (sum(Toewijzing) + sum(Afwijzing))

Each record in my table has a 0 / 1 or a 1 / 0 value for these two fields.

Now I want to plot the acceptance percentage in a graph, showing this year and the past 3 years (Y-axis percentage, X-axis months). I want to give it a try using set analysis (to which I'm sort of a newbie), but I wonder how to do this, as multiple sums in one statement are not possible.

Anyone any idea how I should go about this?

[hansdevr]

Both solutions worked, thank you both very much!!

I was especially happy to see, that both solutions came close to what I suggested, so my train of thought was in the right direction.

Unfortunately, I could only mark one solution as correct....