Counting condition

[#1]

Hi everyone,

I have a table where I present the data in field which is equal to chocolate:

Count

({$<Product={"Choco"}>}Dia)

Now I want to show the numbers of products equal to "Choco" where the price is higher than 3.

Does anyone know how can I accomplish that?

I tried to use the field Condition on the tab Expression but I think it didnt work. Does anyone know how I can put a condition (AND) on the expression?

Thanks in advance!

[Anonymous · Accepted solution]

Hi!

You can try this:

Count({$<Product={"Choco"},Price={">3"}>}Dia)

Regards,

Gabriel

[#3]

Hi,

I also have difficulties with multiple conditions.

(count({<[Status]={'Perdue'}>} [ID opportunité])) :THIS one WORKS

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}, [Status]={'Perdue'}>}} [ID opportunité]))   :THIS ONE DOESN'T WORK

Any help would be more than appreciated!

thank you!