<div>
<div class="content wysiwyg-content">
I am working on a BO report(free hand SQL) where I have two products A and B, a customer has a option to opt for any 1 product or both, the issue is that the amount is repeated twice if he opts for both products and the total revenue is not correct.<br />
<br />
&nbsp;How do I make the report to show the amount only one time.<br />
<br />
ex:<br />
Account # &nbsp;Product &nbsp; &nbsp;Amt<br />
&nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
&nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
&nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20<br />
<br />
I should have a total of 30<br />
<br />
I am new to BO, not sure if this is possible or not, but I would appreciate any help.<br />
<br />
Thank you<br />
<br />
&nbsp;<br />
<br />

</div>
</div>


I am working on a BO report(free hand SQL) where I have two products A and B, a customer has a option to opt for any 1 product or both, the issue is that the amount is repeated twice if he opts for both products and the total revenue is not correct.

 How do I make the report to show the amount only one time.

ex:
Account #  Product    Amt
     1               A           10
     1               B           10
     2               A           20

I should have a total of 30

I am new to BO, not sure if this is possible or not, but I would appreciate any help.

Thank you

 



Need help with query or a formula in BO XI

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.