Column calculation in Pivot table stops after 130 lines

[Marius_]

Highlight shows column calculation that stops abruptlyHi guys (and guydettes :-))

I am using s running total in pivot to calculate cumulative sales orders. From there I must calculate the remaining Salesorders per day after goods were issued.

I used column calculations to try to keep my formulas easy. So far so good.

But the column calculations stopped abruptly after +- 130 lines, then starts up again at the next plant and stop again after +- 100 lines and so forth.

There is no problem with the running total calculation:

rangesum(above(total Sum({<DocType={'1Salesorder'}>}Quantity), 0, rowno(total)))

But the column calculations acts weird:

if(Column(8)<> Column(9), Column(11),Above(Column(13),1,1))

Please see JPG files 

Any idea why this would happen? 

 Marius

[rubenmarin]

Hi, there is no JPG files.

[Marius_]

Sorry, new at this

See upload