Running Total/Increment That Restarts after NULLs

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!

Transformation

Accepted answers

davidskaife

Hi @nero_t

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

Running Total.yxmd

All comments

davidskaife

Hi @nero_t

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

Running Total.yxmd

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!!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703