KPI:Marja neta

From docs
Revision as of 14:48, 4 May 2015 by Georgian Rosu (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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