Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to use the count function using a set analysis expression and with two conditions in it.
This is my expression:
= count({<ORDER_BOOKED_DATE>Today()-7, PROMISE_DATE<Today()+30>}LINE_NUMBER)
ORDER_BOOKED_DATE and PROMISE_DATE are fields of date type. So basically i want to count orders that have been registered more than a week ago and with a promised date less than a month.
This does not work. Is there something i'm doing wrong?
Help please!
Thanks.
Tatiana
try this expression:
=Count({<ORDER_BOOKED_DATE = {"$(='<' & Date(Today()-7, 'DD/MM/YYYY'))"}, PROMISED_DATE = {"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}>}LINE_NUMBER)
Hi Tatiana,
Try the following:
= count({<ORDER_BOOKED_DATE = {">$(=Today()-7)"}, PROMISE_DATE = {"<$(=Today()+30)"}>}LINE_NUMBER)
What is your date field format here? (for ORDER_BOOKED_DATE and PROMISE_DATE)?
Hi Talwar,
The date format is: DD/MM/YYYY for both fields
Hi Niclas,
I have tried this but it doesn't work. The count gives a result of 0
Try this
=Count({<ORDER_BOOKED_DATE = {"$(='>' & Date(Today()-7, 'DD/MM/YYYY'))"}, PROMISE_DATE {"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}>}LINE_NUMBER)
Still doesn't work.
It says there is an error into the set modifiers expression
Please share some sample data.
My bad, missed an equal sign, try this
=Count({<ORDER_BOOKED_DATE = {"$(='>' & Date(Today()-7, 'DD/MM/YYYY'))"}, PROMISE_DATE = {"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}>}LINE_NUMBER)
I double checked and it seems like the second condition (PROMISE_DATE={"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}) does not applied in the expression.