Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Insert a Sum or addition of 2 values in a rml report

By
Leopo
on 6/13/16, 10:40 PM 183 views

Hi,

How I can add 2 values in a RML report, I need do something like:

Account invoice report in table line get the result of  (amount_total - residual), I try lambda, but doesn't work, and I don't really understand how its works.

Thanks for help me.

<para style="terp_default_8">[[repeatIn(getLines(o), 'line') ]]</para>

<blockTable colWidths="80.0,100.0,100.0" style="Table3">

<tr>

<td>

<para style="terp_default_Centre_9">[[ formatLang(line['date_due'],date=True) or '' ]]</para>

</td>

<td>

<para style="terp_default_Right_9">[[ company.currency_id.symbol ]] [[ formatLang(line['amount_total']) ]] </para>

</td>

<td>

<para style="terp_default_Right_9">

[[ formatLang((reduce(lambda x, y: x['amount_total']) - (y['residual']), 0))) ]]

</para>

</td>

</tr>

</blockTable>

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/13/16, 10:40 PM
Seen: 183 times
Last updated: 6/13/16, 11:58 PM