Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Does anybody have charts of calculating age wise outstanding of stock (Inventory ) logic from MS Navision System ,
Please share logic how to do this.
-----------------------------------------------------------------------------------------------------------------
Item Name 0-30 31-60 61-90 91-180 >180 Tot Inv Value
-----------------------------------------------------------------------------------------------------------------
Xyz 10 20 40 7 3 80
Vikas
You can use the class function nested in an if statement:
Load
if(Something>180,'>180', class(Something,30)) as BucketsOfSomething
FieldX,
FieldY,
etc
From ...somewhere...