Hi,
Declare @fltAdjQuantity as float
Set @fltAdjQuantity = 1.0714285714285714
select @fltAdjQuantity
select @fltAdjQuantity - 1
I checked you above query and it is giving me
0.0714285714285714
which you need as an answer.
Pls elaborate your question.