Why does RoundTo not work for me? 1

[delphiman]

I have Math in my Uses clause but neither of the following will work for me. I need
dm.tblMStockInitSqMtrs.Value to be limited to TWO decimal points.

  tblMStocksqMtrs.Value := RoundTo(tblMStockHght.Value * tblMStockWdth.Value);

OR

  RoundTo(tblMStocksqMtrs.Value) := (tblMStockHght.Value * tblMStockWdth.Value);

 

[earthandfire]

Just follow the example by whosrdaddy in your original post

 

[gcaramia]

tblMStocksqMtrs.Value := RoundTo(tblMStockHght.Value * tblMStockWdth.Value, -2);

Giovanni Caramia

 

[KempCGDR]

And note that posting something that is essentially the same problem in a new thread is frowned upon at best and against the rules at worst, because of cluttering up the board listing and such-like. As stated, how to do it was given to you, roundTo requires two parameters.

 

[delphiman]

gcaramia

Thanks from "downunder" Mate! For studying my problem PROPERLY!

THIS works. A star for you.

tblMStocksqMtrs.Value := RoundTo(tblMStockHght.Value * tblMStockWdth.Value, -2);

KempCGDR

>And note that posting something that is essentially the same problem in a new thread is frowned upon at best and against the rules at worst

If those who endeavour to make a contribution couldn't be bothered to READ the problem PROPERLEY [in the 1st thread] and as a result provide silly suggestions such as provided by earthandfire to "Just follow the example by whosrdaddy in your original post" - which effectively and obviously takes me in an un-ending circle what alternative do you suggest? OTHER than putting the same problem differently and in a different thread. Taking note that the solution by gcaramia makes SENSE at the very least AND IN FACT solves the problem.

Whilst YOUR advice "As stated, how to do it was given to you, roundTo requires two parameters " is as totally useless to me as a wheel-barrow in a rowing-boat - compared with that provided by gcaramia! [More advice for you on this in my thread102-1031488]

 

[earthandfire]

My understanding of your problem was that you needed to be able to return the result of a calculation correct to 2 decimal places.

Please accept my sincerest apologies if that understanding was in any way flawed.

However, based on that understanding, RoundTo(1.234, -2) = 1.23 is a perfectly corrrect and valid example to provide. You, yourself stated that 43.6743 should be 43.67.

Additionally, the solution that you praised so highly makes EXACTLY the same assumption.

 

[KempCGDR]

As earthandfire just said, the only difference between the solution from gcaramia and the one from everyone else was that gcaramia's solution didn't require any thinking at all on your part. The 1.234 in the original solution is the input value, you replace it with whatever you're passing in.

 

[delphiman]

Case closed