SQL Server 2014 Computed Column Specification Calculated Field Formula Error

Question

Using the below column names in the formula field of computed column specification category (using Management Studio).

[[App_1]+[App_2]+[App_3]+[App_4]]

I'm getting this error:

'MyDatabase' table
Error validating the formula for column 'Total'.

App_1, App_2, App_3, App_4 all are numeric values.

Anyone knows how to handle this?

@Jaco, I tried your suggestion also but getting the same error — Sixthsense, Mar 30 '16 at 09:31
@JaydipJ, I created the table using SSMS not using SQL so unable to provide you the script. — Sixthsense, Mar 30 '16 at 09:32
You can obtain the table script from SSMS by right clicking on the table and selecting *Script Table As* > *CREATE To* > *New Query Editior Window* from the menu. — David Rushton, Mar 30 '16 at 09:40
@Tom Chantler, Total Column Data Type is Int. App_(1234) are Bit. — Sixthsense, Mar 30 '16 at 09:41
@destination-data, I am a newbie with sql codes so SSMS is the only way I can able to do the changes. — Sixthsense, Mar 30 '16 at 09:42
Seeing the table script will help us figure out why the computed column isn't working for you. If you could edit your question to include that would be great. — David Rushton, Mar 30 '16 at 09:44

Giorgos Betsos · Accepted Answer · 2016-03-30T09:42:03.663

1

You have to get rid of the enclosing square brackets ('[', ']'), use:

[App_1]+[App_2]+[App_3]+[App_4]

Alternatively you can try with an SQL script:

ALTER TABLE [dbo].[mytable] ADD [new_col] AS ([App_1]+[App_2]+[App_3]+[App_4])

edited Mar 30 '16 at 09:42

answered Mar 30 '16 at 09:28

Giorgos Betsos

Thanks for the reply. I tried your suggestion but getting the same error. – Sixthsense Mar 30 '16 at 09:30
@Sixthsense Which version of Management Studio / SQL Server are you using? – Giorgos Betsos Mar 30 '16 at 09:31
@Sixthsense It executes ok on my end (with the same version) – Giorgos Betsos Mar 30 '16 at 09:34
@Sixthsense You didn't mention the the fields are of type `bit`. You said `numerical`. Its not the same thing. – Giorgos Betsos Mar 30 '16 at 09:45
@ Giorgos Betsos, you fixed it. LOL how silly I am!!! The bit part made the real hassle. I changed all the fields as int then your suggested syntax worked perfectly. "[App_1]+[App_2]+[App_3]+[App_4]". Thank you very much!!! – Sixthsense Mar 30 '16 at 09:51

1 Answers1