2 Replies Latest reply on Sep 12, 2013 6:52 PM by Olga12

    use formula in the data model query

    Olga12

      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