Combining two different conditions in set analysis

[hppflpp]

Hi all, 

I have a question regarding set analysis. 

I want to calculate a percentage of a sample from the total and display only data from previous year. 
As Total can't be 0, I want to prevent this. 

After a long research, I thought this should be working:

Sum({$<StatYear={$(=max(StatYear)-1)}>*<Total = {">0"}>} [Sample]/[Total])

While the formula seems ok regarding syntax, the output can't be correct, numbers are way too high. 
I can't imagine what's happening there and I don't know how to fix this. 

[agigliotti]

Hi @hppflpp ,

To me what you are trying to achieve it's not clear, could you post a sample app with mock data?

[hppflpp]

Hi @agigliotti , of course.

What I want to do is: I want to calculate the percentage (Sample / Total) from previous year, but as Total can be 0 (it's not in my example, but in my original file), I want to prevent destroying mathematics by only picking those lines where Total is bigger than 0.

In this case by the way the equation shows 0. After restarting the file I'm actually working on, this also shows 0. What did I miss?

[agigliotti]

maybe this:

=Sum(Sample)
/
Sum( {< StatYear = {$(=max(StatYear)-1)} > TOTAL Sample )

I hope it can help.

Best Regards