2 Replies Latest reply: Oct 2, 2013 1:44 PM by 1044720 RSS

    BI Publisher - Post SQL Calculations in Report

    1044720

      Hello Everyone,

       

      I had a question on how to perform calculations on the results of the SQL. For instance, I have a report that is giving me counts of customer records and their corresponding status (pending, success, denied, canceled, etc) and I want to count them at different levels, all the customers for each employee, their store name, and the region. I was able to do this in BusinessObjects Webi quite easily, but I'm having trouble in BI Publisher.

       

      Thanks in advance,

       

      -Gil