If formula issue

I keep getting an error for the below formula. "The error is "invalid type in operator >." Both of my variable items are in double data type. Can't get what is wrong. Thanks for the help guys

IF [Charged Hours] > 0 THEN "Keep" ELSEIF [Budget Hours]>0 THEN "Keep" ELSE "Filter" ENDIF

Workflow

Accepted answers

jonathanzadeh

I found the issue and you guys pushing me about the data type pushed me to figure it out. I was using the join tool to change it to a double, then i used a union tool. For some reason after the union tool the data type changed back to a string. I used the select tool to fix the issue. Thanks guys

All comments

jamielaird

hi @jonathanzadeh

Are you 100% sure that [Charged Hours] and [Budget Hours] are numeric fields, and that the field you are creating or editing in the formula tool is a string field?

Thableaus

Hi @jonathanzadeh

Charged Hours or Budget Hours are probaly String types. At least one of them.

Check that.

Cheers,

jonathanzadeh

I posted the screenshot

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703