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.
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.