Odoo Help


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.


Problem in condition check in openoffice report.

on 3/25/14, 2:06 AM 892 views

I have a problem in checking multiple conditions in my openoffice report for openerp in my report i need to check conditions and prints the results.

my condition is.

[[ (l.invoice_line_tax_id.name[0] =='5 %' )and formatLang(l.price_unit /1.05) or (l.invoice_line_tax_id.name[0] == '14.5 %') and formatLang(l.price_unit/1.44) or formatLang(l.price_unit) ]]

in this first check tax name == '5 %' then print l.price_unit/1.05 then evaluate the or condition if tax name == '14.5 %' prints the value of l.price_unit/1.44, else print l.price_unit.

But there is a problem in my report it works fine when tax name == '5 %' and print its corresponding value, then it evaluate the false condition by printing the else value (l.price_unit) , It does n't evaluate the or condition (or (l.invoice_line_tax_id.name[0] == '14.5 %') and formatLang(l.price_unit/1.44)) .Any one please help me to find the solutions.

shashank verma
On 3/25/14, 3:55 AM


Why will OR condition would work if your 1st condition already statisfied?

(l.invoice_line_tax_id.name[0] =='5 %' )and formatLang(l.price_unit /1.05) is true then or condition wont work.

in case (l.invoice_line_tax_id.name[0] =='5 %' )and formatLang(l.price_unit /1.05)=False

your OR (l.invoice_line_tax_id.name[0] == '14.5 %') and formatLang(l.price_unit/1.44) will work

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

0 follower(s)


Asked: 3/25/14, 2:06 AM
Seen: 892 times
Last updated: 3/16/15, 8:10 AM