REG Oracle Discoverer

[vamsioracle]

Hi

I am working on a discoverer report with minimum knowledge. have an issue where in i need to execute two different formula or calculations based on a condition

if the loan type is of soft then one formula to calculate the loan balance
if loan type is mortgage then other formula

how to go about it

can i use new calculation dialog box and implement this

case loan_type is "soft"
then
loan bal = ......
case loan_type is motgage....
....

Is this ok or can i diretly edit the query

please help me

[amitpatel66]

Hi

I am working on a discoverer report with minimum knowledge. have an issue where in i need to execute two different formula or calculations based on a condition

if the loan type is of soft then one formula to calculate the loan balance
if loan type is mortgage then other formula

how to go about it

can i use new calculation dialog box and implement this

case loan_type is "soft"
then
loan bal = ......
case loan_type is motgage....
....

Is this ok or can i diretly edit the query

please help me

If the query is used or referred by only single work space/business area, then you can directly edit the query. if the query is referred by more than one work space, then its better to add the calculations seperately for that work space particularly... .