KPI:Marja neta: Difference between revisions

From docs
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 '702%'
or den.ContContab like '703%'
  or den.ContContab like '703%'
or den.ContContab like '704%'
  or den.ContContab like '704%'
or den.ContContab like '705%'
  or den.ContContab like '705%'
or den.ContContab like '706%'
  or den.ContContab like '706%'
or den.ContContab like '707%'
  or den.ContContab like '707%'
or den.ContContab like '708%'
  or den.ContContab like '708%'
or den.ContContab like '709%'
  or den.ContContab like '709%'
or den.ContContab like '7411%'
  or den.ContContab like '7411%'
then x.RCvaluta
  then x.RCvaluta
  when
  when
den.ContContab like '711%'
  den.ContContab like '711%'
   or den.ContContab like '712%'
   or den.ContContab like '712%'
then isnull(x.RCvaluta,0) - isnull(x.RDvaluta,0)
  then isnull(x.RCvaluta,0) - isnull(x.RDvaluta,0)
  when
  when
den.ContContab like '721%'
  den.ContContab like '721%'
or den.ContContab like '722%'
  or den.ContContab like '722%'
or den.ContContab like '758%'
  or den.ContContab like '758%'
or den.ContContab like '7417%'
  or den.ContContab like '7417%'
or den.ContContab like '7815%'
  or den.ContContab like '7815%'
then x.RCvaluta end as VenituriExploatare,
  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