KPI:Marja neta

Calculeaza marja neta contabila:

Formula:

  VenituriExploatare - CheltuieliExploatare
+ VenituriFinanciare - CheltuieliFinanciare
+ VenituriExtraordinare - CheltuieliExtraordinare
- ImpozitProfit
- AlteCh

Unde:

VenituriExploatare:

when den.ContContab like '701%'
or	den.ContContab like '702%'
or	den.ContContab like '703%'

or den.ContContab like '704%' or den.ContContab like '705%' or den.ContContab like '706%' or den.ContContab like '707%' or den.ContContab like '708%' or den.ContContab like '709%' or den.ContContab like '7411%'

then x.RCvaluta
when

den.ContContab like '711%'

 or	den.ContContab like '712%'

then isnull(x.RCvaluta,0) - isnull(x.RDvaluta,0)

when
den.ContContab like '721%'

or den.ContContab like '722%' or den.ContContab like '758%' or den.ContContab like '7417%' or den.ContContab like '7815%'

then x.RCvaluta end as VenituriExploatare,