Hello guys! Just wanted to know if anyone already encountered this error on formula field when making case when formulas?

"Error converting data type varchar to float"

I'm trying to make a very simple case when formula but I keep getting that error. I tried to use the same formula in calculated fields but I just got a normal "Invalid formula" error.

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## imJihyo

Hello guys! Just wanted to know if anyone already encountered this error on formula field when making case when formulas?

"Error converting data type varchar to float"

I'm trying to make a very simple case when formula but I keep getting that error. I tried to use the same formula in calculated fields but I just got a normal "Invalid formula" error.

Any help will be much appreciated!

- Jihyo ♥## Link to comment

## Share on other sites

## 2 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.