I have a decimal column and another column that does a calculation based on the decimal column. I only want to use the decimal part not the whole number. How can I have it return only the decimal part? So, if I have 150.742, on the decimal column, I want it to return .742 on the other column so I can make my calculation.
Thank you.
Solved! Go to Solution.
([Decimal] - FLOOR([Decimal]))
([Decimal] - FLOOR([Decimal]))
That did the trick! Thank you @Steve
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
11 |