This discussion is archived
3 Replies Latest reply: Sep 12, 2012 9:26 AM by David Allan RSS

use of expression

user409028 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points