KPI:Marja neta
Revision as of 14:48, 4 May 2015 by Georgian Rosu (talk | contribs)
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