Calculating a reimbursement amount for swim instructor for low-income children
I have an app that needs to calculate the reimbursement paid to a swim instructor for low-income families.
The current formula that I have only works for CHILD 1.
var WR = @INSTRUCTOR WEEKLY RATE;
WR > 100 ? 50*@NUMBER OF WEEKS : WR < 101 ? WR*@NUMBER OF WEEKS/2 : ""
I need the same formula, but to include NUMBER OF WEEKS FOR CHILD 2, CHILD 3, CHILD 4 AND CHILD 5 and add the correct sum of up to the maximum number of children a family may have.
Thank you so much!
Please sign in to leave a comment.