Issue in Business View Formula Column

[Maran_Rengasamy]

Hi Team,

I have created a business view with Formula Columns.

In one Formula Column(ORG_SLS) logic, I'm using the existing formula columns. When I use the ORG_SLS column in dashboard, I'm getting the below error.

"INC_10010110: The column doesn’t contain a numerical value. Enter a field or constant with a numerical value, such as -2 on [Org Sales]"

What this error means. When I rearange the logic, the ORG_SLS working fine. If I add some additional logic, I'm getting the above error.

Can anyone help me on this error?

[dylanwan]

Can you share the formula column and the business view formula logic? 

[JoeM]

Hi @Maran_Rengasamy - Is this something that you were able to resolve?

[Maran_Rengasamy · Accepted solution]

Hi Dylan and JoeM,

Sorry for the delayed response.

I have resolved this issue.

I'm using multiple logic combinations in the formula column. the order of the logic caused the above error. So I changed the logic order with proper AND/OR/IN condition in the CASE statement and it worked.

Thanks