Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Amy Chan
    Formula to sum up lines
    Topic posted September 18, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged BI Publisher, OTBI 
    41 Views, 5 Comments
    Title:
    Formula to sum up lines
    Summary:
    Formula to sum up lines
    Content:

    Hi all,

    Just wondering if I have PO lines say 3 lines and I want to display the total sum of the PO amount. How to do it in BI publisher? Or I must go back to OTBI data model to have this amount in header level?

    Thanks.

    Comment

     

    • Ramesh Nayak

      Amy,

      You need to write a subquery to get only sum of the PO amount and after that you can join this query to other query based on header_id if you need any help on query please let me know.

      Thanks,

      Ramesh

      • Amy Chan

        Hi Ramesh,

        So I cannot do it directly in BI publisher template.... must go back to OTBI to get this information, right?

        Thanks.

      • Amy Chan

        Hi Ramesh,

        So I cannot do it directly in BI publisher template.... must go back to OTBI to get this information, right?

        Thanks.