Issue with calculated column (decimals)

[Trapatoni]

Hello community,

I'm struggling with a calculation in a column.

It is a quite easy calculation.

The formula is as follows:

[theoretical consumption]] = [Actual Qty]*[Film in kg]*2/1000

1st row is calculated wrong: It should be 218,85

2nd one looks OK.

Is it a problem of decimal, 1000 seperator, language settings?

Any idea how I could solve that?

Many thanks in advance

[Anonymous]

Hi,

I would Advise you to use Brackets when handling functions. Second, Try and check the Thousands Separator under Modelling to check if the issue is caused by that.

---

@Trapatoni wrote:

Hello community,

I'm struggling with a calculation in a column.

It is a quite easy calculation.

The formula is as follows:

[theoretical consumption]] = [Actual Qty]*[Film in kg]*2/1000

1st row is calculated wrong: It should be 218,85

2nd one looks OK.

Is it a problem of decimal, 1000 seperator, language settings?

Any idea how I could solve that?

Many thanks in advance

---

---

@Trapatoni wrote:

Hello community,

I'm struggling with a calculation in a column.

It is a quite easy calculation.

The formula is as follows:

[theoretical consumption]] = [Actual Qty]*[Film in kg]*2/1000

1st row is calculated wrong: It should be 218,85

2nd one looks OK.

Is it a problem of decimal, 1000 seperator, language settings?

Any idea how I could solve that?

Many thanks in advance

---

[Trapatoni]

@Anonymous 

Thanks for the quick reply.

If I activate thousands seperator in the modelling tab I just get 2188,5 -> 2.188,5

I checked some further rows and it seems to be an issue of the number of decimals of column [film in kg]

If somebody could explain me that i would really apreciate it.

By using brackets you mean

[theoretical consumption] = ([Actual Qty]*[Film in kg]*2/1000)

instead of

[theoretical consumption] = [Actual Qty]*[Film in kg]*2/1000

?

[Trapatoni · Accepted solution]

For any reason the column [film in kg] was formated as datatype: text.

I dont know why it was working for some lines, but after change the type to decimalnumber, the calculation works fine.

I mark the thread as solved