Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Decimal places

kdoankdoan Member Posts: 3
Hello,
I have a table with Results column (data type = float) and a DecDigits Column (Data type = smallint). I need to creat a view to show the results column according to the DecDigits column for example:

Results = 0.1256 with DecDigits = 2 ==> in View to show Results = 0.13

Results = 3.6 with DecDigits = 0 ==> in View to show Results = 4

Results = 3.14 with DecDigits = 1 ==> in View to show Results = 3.1

Can anyone help?

Sign In or Register to comment.