IF ELSEIF Problem

[Former Member]

Hi, I am trying to do some math in the first IF statement: divide total by 2. When I look at my report the I am seeing the ({@Total}/2). Here is my formula:

If (CurrentDate> {@21Days}) OR (CurrentDate >{@LastMonth})THEN "NOTICE OF TERMINATION OF CHILD CARE CONTRACT FOR NON-PAYMENT OF FEES." + chr(10)"" chr(10)+ "You must pay at least 50% of the total due:" + "({@Total}/2)"

ELSE

If (CurrentDate<{@LastMonth}) THEN "SECOND WEEK NON-PAYMENT/PARTIAL PAYMENT NOTICE"

ELSE

If {tblAROpenDoc.dtmDocDate} in LastFullWeek THEN "FIRST WEEK NON-PAYMENT/PARTIAL PAYMENT NOTICE" ELSE ""

Does anyone know what I should be doing? Thanks.

[Former Member · Accepted solution]

Hi BJ,

I think it might work if you replace "({@Total}/2)" with ToText({@Total}/2). Leave off the quotes. ToText will convert the number to a string.

Hope that helps,

Cyndi

[Former Member · Accepted solution]

Thanks. That did the trick!