KPI:Marja neta: Difference between revisions
Jump to navigation
Jump to search
Created page with "Calculeaza marja neta contabila: Formula: VenituriExploatare - CheltuieliExploatare + VenituriFinanciare - CheltuieliFinanciare + VenituriExtraordinare - CheltuieliExtr..." |
No edit summary |
||
| 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 14: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