3 Replies Latest reply: Sep 12, 2012 11:26 AM by David Allan-Oracle RSS

    use of expression

    user10958385
      Dear all,

      I have written a expression in expression oprator. the expression i have written i want to use it for other calculation as well in the same expression oprator. to reuse with some more formula i want to use variable which is there in expression Oprator in OWB11gr2.

      if i declare some thing as a variable then how can i use it in other calculation as i can't get the reference of variable.

      Any help.

      eg

      variable name com_cal

      formula
      DECODE( EXP_NRT.USER_DETAIL_FLAG ,'U', EXP_NRT.TRANSACTION_END_TIME
      - NUMTODSINTERVAL( (EXP_NRT.RESPONSE_TIME + NVL(NVL( EXP_NRT.AVG_NRT , EXP_NRT.DEFAULT_NRT ),0) * EXP_NRT.NRT_COMMON -
      nvl( EXP_NRT.LOCAL_SERVICE_EXCLUDED ,0) - (nvl( EXP_NRT.LOCAL_SERVICE_UNKNOWN ,0) * EXP_NRT.UNKNOWN_LOCAL_TIME ) -
      nvl( EXP_NRT.EXTERNAL_SERVICE_TIME ,0) - nvl( EXP_NRT.WAIT_TIME ,0) - nvl( EXP_NRT.SPINE_TIME ,0))
      ,'SECOND'),NULL)


      now i want use the output of the above as input in other column so that i can extract the timepart from the above.

      if i declare the above as vaable then i don't know how to refer the variable in calculation as it doesn't appear in the column list in expression operator