Forum Discussion
Issue with calculated column (decimals)
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
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
?
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