Forum Discussion
Issue with calculated column (decimals)
Hello community,
I'm struggling with a calculation in a column.
It is a quite easy calculation.
The formula is as follows:
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
3 Replies
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/10001st row is calculated wrong: It should be 218,852nd 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/10001st row is calculated wrong: It should be 218,852nd one looks OK.Is it a problem of decimal, 1000 seperator, language settings?Any idea how I could solve that?Many thanks in advanceAnonymous
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
?
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
