Forum Discussion

RudyL's avatar
RudyL
Helper I
2 years ago
Solved

Absence streak

Hi, The request may look familiar but I can't figure it out with the examples in the community. So I put in a new one.  I have a table like the one below (first five columns). All employees are cro...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi RudyL 
    You are right the ABSSTREAK calculated column. However I could not generate the other problem. Looks like the engine treats the blank as a zero anyway. I have a added a COALESCE statement as an additional layer to confirm the result.

     

RudyL's avatar
RudyL
Helper I
2 years ago

Hi tamerj1 , please see my example data that i gave in reply to another contributor. With this sample data your solution doesn't seem to work.

tamerj1's avatar
tamerj1
Community Champion
2 years ago

Hi RudyL 
You are right the ABSSTREAK calculated column. However I could not generate the other problem. Looks like the engine treats the blank as a zero anyway. I have a added a COALESCE statement as an additional layer to confirm the result.