Do you need to use t1 with the calculated column type?
I have the following calculated field code : btw_percentage / 100 + 1.00
However when I tried to add t1. to it. The database gave an error.
But the code as it is written above doesn't work.
Does anyone know how to handle this?
Best answer by Mark Jongeling
SQL server will see 21 / 100, for example, as 0, then + 1.00 is 1.00. This is not intended. When needing calculations like this, you'll need to ensure the tax percentage is of type Numeric (or similar).
+23Hi Maarten,
Specifying t1 is not needed as the column is in the context of the table already. No other tables are available, thus always selecting out of the same table.
What is exactly not working?
One thing I can think of is that btw_percentage has a datatype of type INT. This will not go well with dividing and such.
+23SQL server will see 21 / 100, for example, as 0, then + 1.00 is 1.00. This is not intended. When needing calculations like this, you'll need to ensure the tax percentage is of type Numeric (or similar).
+16As a rule:
As you to your code, when it's an INT you sometimes need to push decimals, I guess in this case you would like to make from 21% a factor 1,21 right?
(100.0 + btw_percentage) / 100.0 If above still gives an error you can always cast btw_percentage as a decimal(5,2) for example.
+9Please see this related idea, which will be available in the next platform release:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
