topic Re: Issue in Business View Formula Column in Data & Schema Discussions

Issue in Business View Formula Column

Maran_Rengasamy — Thu, 28 Nov 2024 10:00:25 GMT

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?

Re: Issue in Business View Formula Column

dylanwan — Mon, 02 Dec 2024 04:10:34 GMT

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

Re: Issue in Business View Formula Column

JoeM — Fri, 06 Dec 2024 19:29:06 GMT

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

Re: Issue in Business View Formula Column

Maran_Rengasamy — Thu, 06 Mar 2025 09:38:09 GMT

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