I have a report that I am trying to make work where I have a schedlog.audittype_id of 1 and I want rows returned with this audittype if two criteria are fulfilled.
1) schedlog.reschedreason_id in 1 to 22
2) schedlog.scheduled_datetime has a date change ONLY. Not just a time change within the same day.
This formula was provided to me but is not working the way I want and should this be a formula or should I put it in the Select Expert as a X-2 for suppression? Or go in the Record Selection of the Formula Workshop? How can I make this work?
(if {schedlog.audittype_id} = 1 and {schedlog.reschedreason_id} in [1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20, 21, 22, 23, 3, 4, 5, 6, 7, 8, 9] and DateValue({schedlog.scheduled_datetime}) <> DateValue({schedlog.scheduled_datetime}) Then TRUE Else False)
1) schedlog.reschedreason_id in 1 to 22
2) schedlog.scheduled_datetime has a date change ONLY. Not just a time change within the same day.
This formula was provided to me but is not working the way I want and should this be a formula or should I put it in the Select Expert as a X-2 for suppression? Or go in the Record Selection of the Formula Workshop? How can I make this work?
(if {schedlog.audittype_id} = 1 and {schedlog.reschedreason_id} in [1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20, 21, 22, 23, 3, 4, 5, 6, 7, 8, 9] and DateValue({schedlog.scheduled_datetime}) <> DateValue({schedlog.scheduled_datetime}) Then TRUE Else False)