Only return decimal not while number

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 Solved
0 2 46
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4
([Decimal] - FLOOR([Decimal]))

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4
([Decimal] - FLOOR([Decimal]))

That did the trick!  Thank you @Steve 

Top Labels in this Space