2 Replies Latest reply: Sep 12, 2013 1:52 PM by Olga12 RSS

    use formula in the data model query


      Hello everyone,

      I am using Oracle Report Builder 10g.

      I have a formula let's say CF_1 in the report counting amount. I need to select records for which this amount is >0. My question is , can I put some how in the WHERE clause in my main query in the data model that I need to pull projects only when formula>0 (for example AND CF_1>0)


      Thank you very much