Datatool control precision

Question

How can I bring down the number of decimal points in following code to only 2:

\documentclass{article}
\usepackage{datatool}

\begin{filecontents*}{test2.csv}
  Name, Age, stDev
  Adam, 17.2344, 3.23333
\end{filecontents*}

\DTLloaddb{mydata2}{test2.csv}

\begin{document}

\begin{tabular}{ll}
  \bfseries Name & \bfseries Age%
  \DTLforeach{mydata2}{\Name=Name,\Age=Age,\stDev=stDev}%
    {%
    \\\Name & $\Age\pm\stDev$
    }%
\end{tabular}

\end{document}

Perhaps this answers your question: How to set the precision in numbers. Alternatively you could also use the number formatting macros from the pgf package : \pgfmathprintnumber[precision=2]{}. — Peter Grill, Jul 09 '13 at 01:28
Welcome to TeX.SX! Usually, we don't put a greeting or a “thank you” in our posts. While this might seem strange at first, it is not a sign of lack of politeness, but rather part of our trying to keep everything very concise. Accepting and upvoting answers is the preferred way here to say “thank you” to users who helped you. — Xavier, Jul 09 '13 at 04:11

Werner · Accepted Answer · 2013-07-09T02:10:30.533

datatool already loads fp which provides \FPround{<out>}{<in>}{<num>}, rounding <in> to <num> decimal places and stores it in <out>. datatool mirrors this with \DTLround (and/or \DTLtrunc if you wish to truncate rather than round):

enter image description here

\documentclass{article}
\usepackage{datatool,filecontents}% http://ctan.org/pkg/{datatool,filecontents}
\begin{filecontents*}{test2.csv}
Name, Age, stDev
Adam, 17.2344, 3.23333
Eve, 17.56789, 3.95445
\end{filecontents*}

\DTLloaddb{mydata2}{test2.csv}

\begin{document}

\begin{tabular}{ll}
\bfseries Name & \bfseries Age%
\DTLforeach{mydata2}{\Name=Name,\Age=Age,\stDev=stDev}%
{%
\\ \Name & \DTLround{\Age}{\Age}{2}\DTLround{\stDev}{\stDev}{2}$\Age\pm\stDev$
}%
\end{tabular}

\end{document}

See p 30 (under section 3 Fixed Point Arithmetic) of the datatool user guide.

Datatool control precision

1 Answers1