Accumulated - DSO

[#1]

Dear,

I balance my AR need to calculate how many days of net sales were needed to remedy my balance.

I have to do in QlikView exactly what I did in the worksheet below, ie Balance_AR - Net Sales, or even become negative zero.

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Perfect!

One question, you can do some similar object?

I would like to calculate the direct object, because I have a large volume of data to process.

[#4]

The idea would do in a PivotTable, in other words, create an expression.

You can?

[Gysbert_Wassenaar · Accepted solution]

Ok, see attached example.