Hello Everyone,
Here is my situation.
I have a field in a table (named QuestionPosition)(type Decimal) that contains values like this:
1 2 3 4 5.1 5.2 5.3 ...
I want to have another field in the same table that stores just the remainder (in the above case a 0 for integer values and the 1 of the 5.1, 2 of the 5.2 etc.
I created the field in the table (named QuestionSubPosition) and tried to set the formula for it to QuestionPosition % 1 but it does not accept the formula.
The part that i do not understand is that i can set the formula to QuestionPosition / 1 it works (but not the results i want).
Any ideas on how i can get the results i want
Corey

Trying to get the remainder of a decimal by using Formula on a field
Brian Pos
Corey:
Maybe something like:
Koolchamp
Use the Modulo function, which returns only the remainder of a number:
http://msdn2.microsoft.com/en-us/library/ms190279.aspx
Buck Woody