Forum Discussion
AlexCertificati
7 years agoQrew Cadet
What's the formula?
WayneMajor
7 years agoQrew Cadet
var number current = Nz([Total Quantity]);
var number received = Nz([Quantity Received]);
var number used = Nz([Quantity Used]); // Nz() will return the number if it isnt null, if it is then it will return 0.
var number total = $current + $received - $used;
$total
var number received = Nz([Quantity Received]);
var number used = Nz([Quantity Used]); // Nz() will return the number if it isnt null, if it is then it will return 0.
var number total = $current + $received - $used;
$total