Set analysis syntax

[regowins]

Hi,

Is this correct? I only want to sum the counter where the due date is within the last 30 days ? It does not seem to be working correctly.

Sum({<Due_Date={">=$(=Today()-30)<=$(=Today())"}>}Late_Counter)

Thanks!

[nilesh_gangurde]

Hi,

Check the Date Format of Due_Date Field and the date comming from today() functions. Both should be same.

-Nilesh

[regowins]

Thanks I will check.