• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

Need help with query or a formula in BO XI

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

 

0
ReddyUD
Asked:
ReddyUD
1 Solution
 
tigin44Commented:
select Account #  Product    sum(Amt) as Amt
from your table
group by Account #  Product
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now