Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi 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
Hi, there is no JPG files.
Sorry, new at this
See upload