Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i have this expression
Count({<[DBN Status ID No]={12}>}distinct [Order No] )
I need it to only return the last weeks data. So [In Branch Date] from today and 7days back.
Try with
Count({<[DBN Status ID No]={12}, [In Branch Date] ={">=$(=Today()-7)"}>} distinct [Order No] )
Ag+
It's returning a zero value.
What is your in branch date field format? May be you need to add that to your set analysis as set analysis is format sensitive.... something like this
Count({<[DBN Status ID No] = {12}, [In Branch Date] ={">=$(=Date(Today()-7, 'DD-MM-YYYY'))"}>} DISTINCT [Order No])
DD-MM-YYYY was an example... make sure to use the format that you have In Branch Date stored as in your dashboard.