Calculate monthly premium

D

dawnecia

At the beginning of the account a deposit premium is received. Each month
the premium earned is subtracted from the deposit premium. Once the deposit
premium is exceeded the client is charged the amount over that amount.

This is the statement used. It works for the first month, the next month
when the deposit is exceeded. It does not work for the 3 month however it
works for the remaining months of the account.

=IIf([txtPremiumEarnedToDate]-[txtDepositPremium]<0,0,
IIf([txtPremiumEarnedToDate]-[txtDepositPremium]>[txtDepositPremium],[txtSumOfPremium],
IIf([txtPremiumEarnedToDate]<[txtDepositPremium],[txtPremiumEarnedToDate]-[txtDepositPremium],[txtSumofPremium])))
 
Top