Counting between two dates not working

[alex-wb]

Hi,

For some reason when I am trying to counts all incidents the occurred between two dates it always misses the dates that have the week ending the max IR_WEEKEND, what is wrong with my code?

Thanks,

if(

Sum(
Aggr(Count({$<
IR_WeekEnd={">=$(=WeekEND(max(IR_WeekEnd),-51))<=$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID)
,IR_WeekEnd))
>0
,
Count({$<
IR_WeekEnd={">=$(=WeekEND(max(IR_WeekEnd),-51))<=$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID))

[abhijitnalekar]

Hi @alex-wb ,

Please modify your expression as below.

if(

Sum(
Aggr(Count({$<
IR_WeekEnd={"='>=' & $(=WeekEND(max(IR_WeekEnd),-51))& '<=' & $(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID)
,IR_WeekEnd))
>0
,
Count({$<
IR_WeekEnd={"='>=' & $(=WeekEND(max(IR_WeekEnd),-51))'<='$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID))

[alex-wb]

@abhijitnalekar  thanks for the response, unfortunately that doesn't work. It doesn't return anything for me.