need help troubleshooting a formula 1

[ktatpe]

I have found a glitch in my report... i know what is causing the problem and i have an idea as to how to fix it but i'm not too familiar w/ IF, THEN, ELSE statements.

i have two fields in a table named:
{itemCount.Refund}
{itemCount.Quantity}

The possible values for {itemCount.Refund} are "True" or "False"

what i want to happen is for {itemCount.Quantity} to display its value if {itemCount.Refund} = "False"; but if {itemCount.Refund} = "True" i want {itemCount.Quantity}= 0

the formula i'm using is:
IF {itemCount.Refund} = "False"
THEN {itemCount.Quantity}
ELSE {itemCount.Quantity} = 0

I get an error message stating "a boolean is required here."

I would greatly appreciate some help.

thank you in advance.

 

[JMcVeigh]

Hi
I think all you need to do is the following

IF {itemCount.Refund} = "False"
THEN {itemCount.Quantity}
ELSE 0

 

[ktatpe]

Thanx for the quick response!!!

I received the same error message stating ""a boolean is required here."

after i click "ok" on the error message, the cursor flashes right before, "False" in the formula. i'm assuming that's where the error lies.

formula:
IF {itemCount.Refund} = "False"
THEN {itemCount.Quantity}
ELSE 0


Once again thank you for your response

 

[JMcVeigh]

Try getting rid of the "" around the word false

 

[ktatpe]

Thank you so much for your help, that was the problem.