PrisonProfessor

Conditional Calculation

Discussion created by PrisonProfessor on Aug 9, 2016
Latest reply on Aug 10, 2016 by PrisonProfessor

I'm trying to calculate an inventory quantity but have not had success in getting the right inventory quantity to display.

 

The records are a portal but all the fields are within the same table 'RecordsOfUsage'

 

I have three fields

 

QtyAdd defined as a number default data value is 0

QtyDistribute defined as a number default data value is 0

QtyInventory defined as a calculation

 

The calculation for QtyInventory is as follows;

 

If (QtyAdd  ≠  0; QtyInventory + QtyAdd; If (QtyDistributed ≠  0; QtyInventory - QtyDistributed;QtyInventory))

 

This is a sample of my results

 

 

Thanks

 

Scott

Outcomes