start counting from null value

[cristianj23a]

Hi Guys.

I have a table where absenteeism is counted and the count is reset when the field FLAG_AUS >1.

but I would like it to restart when in FLUS AUS field it is null.

The current code in the script is as follows.

please help me with this topic.

Greetings.

Attached the qvw.

[ben_pugh]

can't you just add another clause: or isnull(EMPLOYEE_AUS) ?

[ben_pugh]

... in the line that you have highlighted with the red arrow

[cristianj23a · Accepted solution]

I managed to solve the problem.

thanks.