<div>
<div class="content wysiwyg-content">
Hi there,<br />
I'm using WEBI - Business Objects 11.5.<br />
Is there a way in the report to Sum Amounts where there is a distinct - Account Number <br />
Table shows (because of multiple error types).<br />
Account # &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount<br />
1231 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12.00<br />
1231 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12.00<br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10.00<br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10.00<br />
1237 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15.00<br />
Webi Sums &nbsp; &nbsp; &nbsp;=59.00<br />
I need the sum to = 37.00<br />
If it can't be done on the report - if you know how to set it up as a Universe object - please let me know.<br />
Thanks much.<br />
<br />

</div>
</div>


Hi there,
I'm using WEBI - Business Objects 11.5.
Is there a way in the report to Sum Amounts where there is a distinct - Account Number 
Table shows (because of multiple error types).
Account #                          Amount
1231                                      12.00
1231                                      12.00
1234                                      10.00
1234                                      10.00
1237                                       15.00
Webi Sums      =59.00
I need the sum to = 37.00
If it can't be done on the report - if you know how to set it up as a Universe object - please let me know.
Thanks much.



WEBI - Sum Amounts where Distinct Account Number

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.