4 Replies Latest reply on Feb 19, 2016 1:43 PM by Shinichiro Murakami

# Table Calc - Take 2

I posted this earlier and the answer got me part of the way there.  I need help doing the running total calc on the first two columns where there are null values (missing data).  Any ideas on how to get from where I am in the attached workbook to where I need to be, which is shown in the Excel workbook?

Thanks.

• ###### 1. Re: Table Calc - Take 2

Hi Paul,

Can you describe a little more. I checked your workbook you have already got a running sum there. Are you trying to get running sum on the LOD calculations?

-Amanjot

• ###### 2. Re: Table Calc - Take 2

I could not fix 3rd row's blank, but I believe the biggest problem was top row.

Overall looks good? anyways you can verify.

I have changed formula from initial one (which I created!!!) a little bit to eliminate Null value..

[Count]

RUNNING_SUM(zn(lookup(count([EMPL_ID]),0)))

[Fix_Count (copy)]

ifnull(attr({exclude[Months to Change]:sum( {fixed [Months to Change]:count(if [Months to Change]=1 then {fixed [Months to Change]: count([EMPL_ID])} end )})}),PREVIOUS_VALUE(-1))

[Run_Sum / Fix]

[Count]/[Fix_Count (copy)]

Thanks,

Shin

• ###### 3. Re: Table Calc - Take 2

Shin,

I'm pretty new at this, so the help you provided got me pointed in the right direction - exploring how to create LOD calculations.  The project has taken a turn in a different direction, so I don't need to hash this out further, but it was helpful in getting to the end result.  Thank you for your time and effort.

Paul

• ###### 4. Re: Table Calc - Take 2

Don't worry.

Any questions are learning opportunity for me and community.

Thanks,

Shin