Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
dim posttax as double
dim pretax as double
IF {PayrollDeduction.postTax} = true Then
IF SUM({PayrollDeduction.amount}) < 0 Then
posttax = 0
ELSE
posttax = SUM({PayrollDeduction.amount})
END IF
END IF
IF {PayrollDeduction.postTax} = false Then
IF SUM({PayrollDeduction.amount}) < 0 Then
pretax = 0
ELSE
pretax = SUM({PayrollDeduction.amount})
END IF
END IF
formula = posttax + pretax
dim posttax as double
dim pretax as double
dim grandtotal
IF {PayrollDeduction.postTax} = true Then
posttax = posttax + ToNumber(PayrollDeduction.amount)
END IF
IF {PayrollDeduction.postTax} = false Then
posttax = posttax + ToNumber(PayrollDeduction.amount)
END IF
IF pretax < 0 THEN
pretax = 0
END IF
IF posttax < 0 THEN
posttax = 0
END IF
GrandTotal = posttax + pretax
You could use a running total with the Execute When set to Post Tax = 1
Another way would be to have a formula like
Open in new window
Then do a summary on that fieldmlmcc