Truncate numbers without rounding

Question

I have a field that divides a number by 100 and I only want to show two places past the decimal without rounding, would this work for that and would I need to add this to the formula that does the dividing or would this go into a format tab?

Code I was using in the calculate tab:

var grandTotal = +getField("GrandTotal").value;

if (!isNaN(grandTotal) && grandTotal !== 0) {

event.value = grandTotal / 100;
}

Code I was using in the format tab:

event.value = util.printf("%.2f", event.value);

Thank you in advance if you can help.

try67 · Accepted Answer

If you only need to do it once then the full calculation code can be:

var grandTotal = Number(this.getField("GrandTotal").value);
if (!isNaN(grandTotal) && grandTotal !== 0) {
	event.value = truncateNumber(grandTotal / 100, 2);
} else event.value = "";

function truncateNumber(v, nDecimals) {
	var re = new RegExp("\\d+\\.\\d{"+nDecimals+"}");
	var results = (""+v).match(re);
	if (results!=null) return results[0];
	else return v;
}

try67 · Answer

Don't use the Format tab at all for this.

Instead, you can use this function I wrote in your calculation script:

function truncateNumber(v, nDecimals) {
	var re = new RegExp("\\d+\\.\\d{"+nDecimals+"}");
	var results = (""+v).match(re);
	if (results!=null) return results[0];
	else return v;
}

If you define it as a doc-level script, change this line in your code:

event.value = grandTotal / 100;

To this:

event.value = truncateNumber(grandTotal / 100, 2);

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded