by COBS Tech Support » Tue Oct 31, 2006 2:14 pm
For calculating the total line value (quantity x sell) if there is a "box quantity" involved then the calculation is:
Borders->Dimsoldfor * VAL(Borders->Dimqty)
Otherwise it's:
Borders->Sellprice * VAL(Borders->Qty)
In a formula tab of the relevant field object on the VB report the correct calculation would look like this for calculating the line total:
If Borders->Dimcon = 0 .Or. Borders->Dimcon = 1 .Or. Val(Borders->DimQty) = 0
Return Borders->Sellprice * VAL(Borders->Qty)
Else
Return Borders->Dimsoldfor * VAL(Borders->Dimqty)
Endif