Count IFNULL Function [Help please]

Copper Contributor

Hi everyone!

 

I think my formula for the count null if function is wrong.

My expected result:

Jacob_S1585_0-1673045801986.png

However, I got,

Jacob_S1585_1-1673045834728.png

Wondering if someone can take a look and help me with this. I already tried my best and got no luck

 

Link for the file: I tried to upload here, it says file not supported. So, I have to upload to external source.

https://easyupload.io/iklv3n

 

1 Reply

@Jacob_S1585 Edit:

Explanation for new cases:

Jacob_S1585_0-1673052806487.png

Closed cases: *time frame 2

Jacob_S1585_1-1673052872575.png

Unresolved cases:

Jacob_S1585_2-1673052891859.png