topic Re: Combining two different conditions in set analysis in App Development

Combining two different conditions in set analysis

hppflpp — Tue, 16 Feb 2021 13:33:16 GMT

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.

Re: Combining two different conditions in set analysis

agigliotti — Tue, 16 Feb 2021 14:08:18 GMT

Hi @hppflpp ,

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

Re: Combining two different conditions in set analysis

hppflpp — Tue, 16 Feb 2021 15:06:56 GMT

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?

Re: Combining two different conditions in set analysis

agigliotti — Tue, 16 Feb 2021 15:33:05 GMT

maybe this:

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

I hope it can help.

Best Regards