Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, there. Can you help me to correct that expression? Thank you.
Conditions: Today()-8 <= %Datum < Today() and H.NAME1 = 'AA'
Measure: OK
Perhaps this?
Count({<%Datum = {">=$(=Date(Today()-7))<$(=Date(Today()))"}, H.NAME1 = {'AA'} >} OK)
Perhaps this?
Count({<%Datum = {">=$(=Date(Today()-7))<$(=Date(Today()))"}, H.NAME1 = {'AA'} >} OK)
Count({<%Date ={">=$(vMinDate)<=$(vMaxDate)"},H.NAME1 = {'AA'}>}OK)
Create 2 variables as
vMinDate = Date(Today()-7)
vMaxDate = Date(Today())