Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dataset where I have the lines when a article has been sold.
I would like to make a set expressions in which I count the amount of days where an article has more than 2 lines and less than 5 lines. In this case this should lead to the result of 2.
Can anyone help me with a set expression which would make this calculation?
Date | Article | Amount |
21-3-2021 | 123 | 1 |
21-3-2021 | 123 | 1 |
21-3-2021 | 123 | 5 |
22-3-2021 | 123 | 2 |
22-3-2021 | 123 | 1 |
22-3-2021 | 123 | 2 |
23-3-2021 | 123 | 1 |
Much thanks in advance!
Hi @Strooprover , please check if this is what you want :
OP1 :
=count(if(Amount >=2 and Amount <5,Date))
OP2 :
=count({<Amount = {">=2<5"} >} Date)