0 Replies Latest reply on Nov 6, 2013 2:48 AM by Hit Wad

    Pass Through Function (Question)

    Hit Wad

      Hi Admin,

       

      I have an oracle connection and pulling data from two tables by union query. Now i want to calculate value 2 in one variable (Count of c100,c101,) and value 3 in another variable (Count of d100,d101,d102)

       

      I have made new column "CDT" where i am storing value "clear" if ID column starts with "c" and "discount" if ID colum starts with "d"

       

      Below is the sample table for reference.

       

      how we can calculate it using passthrough function.

      RAWSQLAGG_STR("Count(%1)", "[ID]") is working giving me value 5

       

      but RAWSQLAGG_STR("Count(%1)", [CDT]= 'Clear') is not giving me 2 same with RAWSQLAGG_STR("Count(%1)", [CDT]= 'discount') is not giving value 3. Error code is ORA-00936.missing expression

       

      IDDate
      c10001-Sep-2012
      c10104-Sep-2012
      d10006-Sep-2012
      d10108-Sep-2012
      d10210-Sep-2013