Breaks in Data

[mparker123]

Hello All,

I am having trouble breaks in data. I am trying to create a straight table that shows me when data is not entered into a database. I will attach a mocked up version of what i am trying to accomplish.

[sunny_talwar]

Try this as your dimension

=Aggr(If(Sum(HOURS) = 0 and DEPT = '44840', LAN_ID), LAN_ID, MONTH, DAY_NUMBER, YEAR)