Count with multiple conditions

[#1]

Hi,

I have issues with a mutliple count condition function.

Below 2 expressions works fine:

1. (count({<[Status]={'Perdue'}>} [ID opportunité]))
2. (count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}>} [ID offre]))

But when I want to create a new expression by putting the expression 1 inside expression 2 so having 3 conditions in total, it doesn't work.

Here is the expression with which I struggle:

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))", Status={'Perdue'}>} [ID opportunité]))

Many thank for your help!!

PS: I am using Personal edition

[effinty2112 · Accepted solution]

Hi Christophe,

                         There appears to be a curly bracket missing. I've added it in bold here:

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}, Status={'Perdue'}>} [ID opportunité]))

Try it again and good luck

Andrew

[#3]

Awesome you made my day

[effinty2112]

Well Christophe your reply made mine.