Calculated Field convert NVARCHAR to Decimal

Epicor ERP 10
1

Creating a calculated field

convert(decimal,Part.Specification)

Text: Error converting data type nvarchar to numeric

What is my issue?

2

your type (the dropdown above) is set to nvarchar. If you want it to be a decimal, change it to decimal.

This is making some assumptions, but you didn’t really give a lot of into. Like when or where you are seeing the error. Include some screen shots. That helps a lot so that other can understand some context.

3

27
27.JPG944×613 63.6 KB

4

Do you get the error when you run the query? Or when you check the syntax?

5

When I run the query I receive.28

6

there is data in the table that can’t be converted to a decimal. Check the data in there as just a regular view.

If you want it to be a decimal, you’re going to have to clean up the data, and keep in clean.

1 Like
7

What is it you are trying to do? That’s a character field, why do you want it decimal?

8

Maybe blank or null too.

3 Likes
9

How to deal with Null or Blank data?

10

isnull(expression,0)

Honestly though. Use a decimal field. It will be way easier.

2 Likes
11

ROUND(Part.Specification,2)*PartCost.LastMaterialCost

Adding ROUND( at the beginning fixed the formula

thanks all

2 Likes