Expression

[priyarane]

Hi Community,

How to write expression for below one.

DECODE(SUM(case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET') and asset_class_new not in ('CLAIM_OTH_100') then 0 else ead end), 0, 0,SUM(case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET') and asset_class_new not in ('CLAIM_OTH_100') then 0 else ead*k_maturity*365.25 end)/SUM(case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET') and asset_class_new not in ('CLAIM_OTH_100') then 0 else ead end))

[yadav_anil782]

hi,

this is more complex so plz try to share in easy way so we can get your query

[priyarane]

But I got it from my users so nothing else I have...

[maxgro]

DECODE(

  SUM( case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET')

    and asset_class_new not in ('CLAIM_OTH_100')

  then 0

  else ead

  end

  ),

  0, 0,

  SUM( case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET')

    and asset_class_new not in ('CLAIM_OTH_100')

  then 0

  else ead*k_maturity*365.25

  end

  )

  /

  SUM( case when bis_entity_type_new in ('INDIV', 'SME_RETAIL', 'SME_EU_RET')

    and asset_class_new not in ('CLAIM_OTH_100')

  then 0

  else ead end

  )

)

I try

IF(

  SUM(      if(match(bis_entity_type_new, 'INDIV', 'SME_RETAIL', 'SME_EU_RET')

                        and not match(asset_class_new, 'CLAIM_OTH_100')

                      , 0

                      , ead

                ) =0,

  /* if sum() =0 --> 0*/ 

  0,         

  /* else sum() / sum() */

  SUM(      if(match(bis_entity_type_new, 'INDIV', 'SME_RETAIL', 'SME_EU_RET')

                        and not match(asset_class_new, 'CLAIM_OTH_100')

                      , 0

                      , ead*k_maturity*365.25

                )

      )

/

SUM(          if(match(bis_entity_type_new, 'INDIV', 'SME_RETAIL', 'SME_EU_RET')

                        and not match(asset_class_new, 'CLAIM_OTH_100')

                      , 0

                      , ead

                )

    )         

[Gysbert_Wassenaar]

Something like this:

alt(sum(ead*k_maturity*365.25*if(match(bis_entity_type_new,'INDIV', 'SME_RETAIL', 'SME_EU_RET') and not match(asset_class_new'CLAIM_OTH_100'),0,1))/sum(if(match(bis_entity_type_new,'INDIV', 'SME_RETAIL', 'SME_EU_RET') and not match(asset_class_new'CLAIM_OTH_100'),ead)),0)

[priyarane]

let me try