Simple calculations within tabularx-environment

Question

I want to perform simple arithmetic operations for a document in a table in the tabularx environment. There is a column for the quantity, a column for the unit price and a column for the total price, which is the result of the quantity and the unit price. At the end of the table, the total prices per row are to be summed up.

Is there a simple way how I can implement this requirement within the Tex document? Is it possible to access single values (e.q. the total sum) in a later part of the document?

Example-Code:

\begin{tabularx}{\textwidth}{c|X|r|r}
\hline
\tiny {Quantity} & \tiny {Description} & \tiny {Unit price} & \tiny {Quantity * Unit Price} \\ \hline
1  & Product 1 & 2,00 EUR &2,00 EUR \\
\hline
2 &  Product 2 & 5,00 EUR & 10,00 EUR \\
\hline
3 & Product 3 & 4,00 EUR & 12,00 EUR \\
\hline
\multicolumn{ 3}{l}{ all round price } &24,00 EUR \\ \hline
\end{tabularx}

Example result:

Thanks a lot in advance,

BR

Christoph

Answer 1

I think this will do the basic jobs:

\documentclass{article}
\usepackage{spreadtab}
\usepackage{numprint}
\usepackage{tabularx}
\usepackage{multirow}
\usepackage{siunitx}
\renewcommand{\familydefault}{\sfdefault}
\nprounddigits{2}
\STsetdecimalsep{{,}}
\newcommand{\Eur}{{\,EUR}}

\begin{document}
\begin{table}[htbp]
\begin{spreadtab}{{tabularx}{\textwidth}{c|X|N{4}{2}<\Eur|N{4}{2}}}
  \hline
@\tiny Quantity & @\tiny Description & @\multicolumn{1}{r|}{\tiny Unit price} & @\multicolumn{1}{r}{\tiny Quantity * Unit Price} \\ \hline
1 & @Product 1 & 2 & :={a2*c2} \Eur \\
\hline
2 & @Product 2 & 5 & :={a3*c3} \Eur \\
\hline
3 & @Product 3 & 4 & :={a4*c4} \Eur \\
\hline
\multicolumn{3}{l}{@all round price } & :={sum(d2:d4)} \Eur \\ \hline
\end{spreadtab}
\end{table}
\end{document}

Edited:

• to make the code simpler;
• Let the quantity column be an integer.