Running Total/Increment That Restarts after NULLs

[nero_t]

Hi,

I'd like to create a running total, really to increment the number of consecutive days we have value in hours. Is there a way to solve this in Alteryx Desktop?

Alteryx Result screen shot is where I am at, while the Excel screen shot is the result I am looking for.

Thanks in advance!

[davidskaife · Accepted solution]

Hi @nero_t 

The Multi-row Formula tool configured like below should work for you. I've assumed 'Counter' is static:

[Gaurav_Dhama_]

Same approach as @davidskaife but different formula

if isnull([Counter]) then null() else max([Row-1:RunTot_Counter],0)+1 endif 

[nero_t]

Very cool! Thank you!!