Calculate prices

Question

I want to calculate prices in a LaTex file. This means I want to add two numbers with exactly 2 decimal places and I want to multiply these values by an integer.

An other thing is the output format. The numbers should be printed like this: 1.234.567,89 (I want to use this in Germany, and there we write numbers like that).

I know there are many packages for calculation in LaTeX, but I assume/hope there is one especially for money values.

Answer 1

PGF

You might want to take a look at the mathematical capabilities of pgf. I prepared a MWE:

\documentclass{standalone}
\usepackage{pgf}
\usepgflibrary{fpu}
\pgfkeys{
    /pgf/fpu = true,
    /pgf/number format/.cd,
    precision=2,
    fixed,
    fixed zerofill,
    use comma,
    1000 sep={.}
}
\begin{document}
\pgfmathparse{2*(1234.56+9786.45)}
\pgfmathprintnumber{\pgfmathresult}
\end{document}

The output will look something like this

To process huge numbers you need to load the fpu library. (Thank you, Jake)

Alternative

Your questions is a little bit unclear, but if it is only about typesetting currency, you could abuse the siunitx package and do something like this

\documentclass{standalone}
\usepackage{marvosym}
\usepackage{siunitx}
\sisetup{
    group-separator = {.},
    round-mode = places,
    round-precision = 2,
    output-decimal-marker = {,}
}
\DeclareSIUnit\euro{\EUR}
\begin{document}
\SI{1234567.8499999}{\euro}
\end{document}

Which leads to the following output

Answer 2

Henri Menke's answer is very good, but does not cover the case where you want to perform operations on large numbers before displaying them (the range of pgfmath is rather limited). Instead of pgfmath I would use l3fp, which manipulates floating point numbers with 16 significant digits, and a wide range of exponents. That should be enough for you, as long as you don't manipulate quantities above 10^{16} cents (above that, there will be rounding errors).

\documentclass{standalone}
\usepackage{marvosym}
\usepackage{siunitx}
\sisetup{
    group-separator = {.},
    round-mode = places,
    round-precision = 2,
    output-decimal-marker = {,}
}
\DeclareSIUnit\euro{\EUR}
\usepackage{expl3,xparse}
\ExplSyntaxOn
\NewDocumentCommand {\SIeval} {omom}
  { \SI [#1] { \fp_eval:n {#2} } [#3] {#4} }
\ExplSyntaxOff
\begin{document}
\SIeval{(1234567.85 + 252346.42) * 1.196}{\euro}
\end{document}

The fp package can also be used, with a slightly less practical syntax, but wider range, as it manipulates fixed point numbers with 18 digits before and after the decimal point (if I remember correctly).

Answer 3

I would go here with an almost orthogonal answer/comment. The original TeX engine has only integer arithmetic and while TeX is Turing complete language and implementation of floating point arithmetics via integer arithmetic is certainly possible (I believe the name of the package is float-point or something like that) this is a perfect example where using actually LuaTeX engine or PythonTeX package with any engine except the original one seems to me philosophically right way to do this.

I just used PythonTeX over the weekend for the first time as a part of my day job and it is fantastic.

This is quick and dirty lua version. You must use lualatex for this to work!

\documentclass{standalone}
\usepackage{luacode}
\begin{document}   

\begin{luacode*}
 result = 2*(1234.56+9786.45)
 out = string.format("%.2f",result)
 tex.print(out)
\end{luacode*}   

\end{document}

It is almost obvious that you can replace entire Lua code with

\documentclass{standalone}
\begin{document}
\directlua{tex.print(string.format("%.2f",2*(1234.56+9786.45)))}
\end{document}

and forget about loading luacode package all together.

Here is PythonTeX. You must run pdflatex, lualatex, or xelatex once then pythontex script then one more time the engine. It doesn't work with Don's engine!

\documentclass{standalone}
% Begin engine=specific settings
\expandafter\ifx\csname pdfmatch\endcsname\relax
\else
    \usepackage[T1]{fontenc}
    \usepackage[utf8]{inputenc}
\fi
% xetex:
\expandafter\ifx\csname XeTeXinterchartoks\endcsname\relax
\else
    \usepackage{fontspec}
    \defaultfontfeatures{Ligatures=TeX}
\fi
% luatex:
\expandafter\ifx\csname directlua\endcsname\relax
\else
    \usepackage{fontspec}
\fi
% End engine-specific settings

% Generic packages for PythonTeX.
\usepackage{amsmath,amssymb}
\usepackage{fullpage}
\usepackage{graphicx}
\usepackage[svgnames]{xcolor}
\usepackage{url}
\urlstyle{same}    

\usepackage[makestderr]{pythontex}
\restartpythontexsession{\thesection}
\usepackage[framemethod=TikZ]{mdframed} 
\begin{document}

\begin{pylabcode}
result = 2*(1234.56+9786.45)
print("{0:.2f}".format(result))
\end{pylabcode}

\end{document}

As people can see most of the above file are just setting :) Note also that Python has much much better ways to deal with currency computations. Consider above just a toy example.

Answer 4

Pweave

...and here is the Pweave example. It requires only two compilation steps; one less than PythonTeX.

An introductory article to Pweave (and Sweave) can be found here.

The first comment line explains how to install Pweave on a GNU/Linux system. The second line of comment indicates how to compile the .Pnw file in order to obtain the .tex and .pdf files.

In this example, Python uses the system locales to determine the decimal and thousands grouping symbols, as well as the position and type of the currency symbol.

For this to work, the referenced locales need to be installed on your system. The Python comment explains how to so for a Debian GNU/Linux system.

Finally, the \EUR command of the eurosym package prints the officially correct euro symbol. Again, Python code takes care of the symbol substitution.

%sudo easy_install -U Pweave
%Pweave -f tex filename.Pnw | pdflatex -synctex=1 -interaction=nonstopmode filename.tex
\documentclass{article}

%document encoding
\usepackage[utf8]{inputenc}

%official euro symbol
\usepackage{eurosym}

\begin{document}
<%
from locale import setlocale, LC_ALL, currency

def money(value):
    return str(currency(value, grouping=True)).replace('€','\EUR')

amount = 2 * (1234.56 + 9786.45)

#To install additional locales in Debian GNU\Linux: sudo dpkg-reconfigure locales

setlocale(LC_ALL, 'de_DE.utf8')%>
In Deutschland hatt diese L\"{o}sung einen Wert von <%=money(amount)%>.

<%setlocale(LC_ALL, 'de_BE.utf8')%>
In Belgien hatt diese L\"{o}sung einen Wert von <%=money(amount)%>.

<%setlocale(LC_ALL, 'en_IE.utf8')%>
In Ireland, this solution is worth <%=money(amount)%>.

<%setlocale(LC_ALL, 'en_GB.utf8')%>
In the UK, this solution is worth <%=money(0.85504 * amount)%>.
\end{document}