Difference between revisions of "KPI:Marja neta"
(Created page with "Calculeaza marja neta contabila: Formula: VenituriExploatare - CheltuieliExploatare + VenituriFinanciare - CheltuieliFinanciare + VenituriExtraordinare - CheltuieliExtr...") |
|||
| Line 14: | Line 14: | ||
when den.ContContab like '701%' | 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 | when | ||
| − | + | den.ContContab like '711%' | |
or den.ContContab like '712%' | or den.ContContab like '712%' | ||
| − | + | then isnull(x.RCvaluta,0) - isnull(x.RDvaluta,0) | |
when | 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 | |
Latest revision as of 15:48, 4 May 2015
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
