Combined formula works seperately but not together

[pokerace]

Using C10. ODBC compliant database.

I have two formulas that both work seperately but when I try to combine them with an else statement Crystal tells me that the second formula should produce a string value.

if{table1.name}="Smith" and Sum({@hours},{Table2.Client_Number})>0 then "40.00"
else val({table3.rate})/6

Again, these each work seperately but bot together. Any reason as to why? Also, if I change the "40.00" to (40*1) it sill procuces an error.

 

[kskid]

Your values are inconsistent. You have text in the "40.00" and number in val({table3.rate})/6.

Change the "40.00" to 40.00

Change the "40.00" to 40.00.