eliminating decimal point without rounding

Resolved pureswing
(@pureswing)

8 years, 6 months ago
Hello!

I’m trying to get rid of a decimal point without rounding, already tried floor(), ceil(), prec(), ToFixed() without luck.I find out that trunc() do the trick in Javascript, but I don’t know how to implement it in the equation.

This does not work:
```
(function(){

var result = trunc(fieldname2/fieldname4);
jQuery('.equation-result').html(result);
return result;

})();
```
THx for your huge support to this plugins!!
- This topic was modified 8 years, 6 months ago by pureswing.

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author codepeople
(@codepeople)

8 years, 6 months ago
Hello @pureswing,

The equation’s code would be:
```
(function(){
var result = IF(fieldname4, FLOOR(fieldname2/fieldname4), '');
jQuery('.equation-result').html(result);
return result;
})();
```
Please, remember that javascript os case sensitive language.

If the issue persists, please, send me the link to your webpage for checking it in detail.

Best regards.
Thread Starter pureswing
(@pureswing)

8 years, 6 months ago

great, it works, that was fast 🙂 THX !!! ..by the way I found another small problem with a simple division in another field:

fieldname22 = 230
fieldname26 = 7
CF = 233 / 7 = 32.8571428…..
Using prec():
prec(fieldname22/fieldname26,2) = 32.86 which it’s not good, that field has to be consistent with 2 decimals without rounding, in other words I need a 32.85. Any solution around this??

Sorry for bothering you again my friend..
Regards

Plugin Author codepeople
(@codepeople)

8 years, 6 months ago

Hello @pureswing,

PREC(X,Y) “rounds” the X number with Y decimal places. If you want simply truncate the decimal places, the solution would be pure mathematics:

FLOOR(n*100)/100

For example, using your current equation:

FLOOR(fieldname22/fieldname26*100)/100

and replacing the values:

FLOOR(230/7*100)/100 =
FLOOR(32.857142857142854*100)/100 =
FLOOR(3285.7142857142854)/100 =
3285/100 = 32.85

I’m sorry, but the support service does not cover the implementation of the users’ projects (forms or formulas). If you need additional support implementing your project, I can offer you a custom coding service from my private website:

https://cff.dwbooster.com/customization

Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘eliminating decimal point without rounding’ is closed to new replies.

Tags