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 like:
count({<ORDER_BOOKED_DATE={'>$(=Date(Today()-7))'}, PROMISE_DATE={'<$(=Date(Today()+30))'}>}LINE_NUMBER)
Try like:
count({<ORDER_BOOKED_DATE={'>$(=Date(Today()-7))'}, PROMISE_DATE={'<$(=Date(Today()+30))'}>}LINE_NUMBER)
May be create 2 variables like
LET Start = Today()-7
LET End = Today()+30
Then create like below
= count({<ORDER_BOOKED_DATE = {">$(Start)"}, PROMISE_DATE={">$(End)"} LINE_NUMBER)
Or
Simply change your expression to this?
count({<ORDER_BOOKED_DATE={'>$(=Date(Today()-7))'}, PROMISE_DATE={'<$(=Date(Today()+30))'}>}LINE_NUMBER)
=count({<ORDER_BOOKED_DATE={">$(=Date(Today()-7,'OrderBookedDateFormat'))"}, PROMISE_DATE={"<$(=Date(Today()+30,'PromiseDateFormat'))"}>}LINE_NUMBER)
Mae sure to play around with date format if you have not set up like DD-MM-YYYY for Order and Promise
Hi Tatiana,
Try
= count({<ORDER_BOOKED_DATE={">=Date(Today()-7)"}, PROMISE_DATE={"<=Date(Today()+30)"}>}LINE_NUMBER)
Andrey
Hi Anil,
I have already set up the Order and the promise day to the date format. I tried your expression but the count is 0 which is not normal
Thank you guys for the help!
Thank you Anil it works fine
thank you it works!