sum of positive value only
I have Product table and ProductLine table. Product table links to ProductLine by SKU with one to multiple linkage. Here is the fields on each table
SumOnHand = sum(ProductLine::OnHand)
SumOnPO = sum(ProductLine::OnPO)
SumOnSO = sum(ProductLine::OnSO)
SKU (linked to Product)
All of Sum fields work correct. If I want to sum the positive value of OnSO only. How can I do it? For example, I have OnSO five records and values are 12, 40, 3, -10, -3. Current the value of SumOnSO is 42 (=12+40+3-10-3). I need a calculation which sums positive value only. It will be 55(12+40+3).