Link to home
Start Free TrialLog in
Avatar of Gerhardpet
GerhardpetFlag for Canada

asked on

Crystal Formula returns "A boolean is required here"

I have this formula and I get "A boolean is required here" when I verify to see if it works. Can someone help me with this?

if {?BV99PS19TenderType1} = "Cash and Cheque Receipts" then "Cash" or 
if {?BV99PS19TenderType1} = "" then "A/R - on account"
else {?BV99PS19TenderType1}

Open in new window


 User generated image
Avatar of JayConverse
JayConverse
Flag of United States of America image

That error is exactly what it says.  Where are you putting this formula?  If it's anywhere in a conditional formatting formula, the result has to be True/False.
Avatar of Gerhardpet

ASKER

I'm pretty new to Crystal so can you tell what the formula should look like? It is not in a conditional formatting formula.
Is that the whole formula?  If not, show the whole thing.  My point is if the upper part is True/False, the lower  part can't be a string.
That is the whole formula
ASKER CERTIFIED SOLUTION
Avatar of JayConverse
JayConverse
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
that was easy...Thank you! Well now you get points for having too much coffee today... :-)