Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi!
You can try this:
Count({$<Product={"Choco"},Price={">3"}>}Dia)
Regards,
Gabriel
Hi!
You can try this:
Count({$<Product={"Choco"},Price={">3"}>}Dia)
Regards,
Gabriel
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!