topic Re: Rounding Currency to Two Digits After Decimal in Splunk Search

Rounding Currency to Two Digits After Decimal

msettipane — Sat, 05 Feb 2011 04:18:49 GMT

I am attempting to round my currency figures to two decimal places whether or not the amount ends with zeros (e.g., $4.00, $0.10); however, it is returning $4 and $0.1.

I am using the following search command: eval cost = "$ " . tostring(round(count*.02, 2), "commas").

Re: Rounding Currency to Two Digits After Decimal

Marklar — Sat, 05 Feb 2011 04:21:52 GMT

Doing this correctly requires some knowledge about significant figures and precision.

In multiplying by the number .02 (which has 1 significant figure), you limit your result to 1 significant figure. The precision is then set from that result.

What you seem to be looking for is exact arithmetic with a precision of 2. The exact() function forces a number to have maximum sigfigs and precision, while the round() function can force your precision. Assuming that count is a non-negative integer, this solution should work for you:

eval cost = "$ " . tostring(round(count*exact(.02), 2), "commas")

Re: Rounding Currency to Two Digits After Decimal

marco_sulla — Fri, 29 May 2015 15:55:55 GMT

IMHO this is completely unexpected and unwanted in the majority of cases. It is supposed this is not a framework for physical calcula...