select 账套名称,
cast(年度 as varchar(10))+'年' as 年度,
case when 期间<10 then '0'+cast(期间 as varchar(10))+'月' else cast(期间 as varchar(10))+'月' end as 期间,
case when 期间<10 then cast(年度 as varchar(10))+'年'+'0'+cast(期间 as varchar(10))+'月' else cast(年度 as varchar(10))+'年'+cast(期间 as varchar(10))+'月' end as 年度期间,
指标名称,行号+指标名称 as 行号指标名称,'期间金额' as 值类型,
isnull((select sum(本期本币金额) from FA_Value_Sunyi as ff where cast(ff.年度 as int) =left('$(日期-年月)',4) and ff.是否包含未记账='$(财务分析_是否包含未记账)' and cast(ff.期间 as int)>0
and ff.指标名称 in ('营业收入','收入总额','营业成本','成本总额','期间费用','营业毛利','营业利润','利润总额','净利润')
and ff.账套名称=t.账套名称 and cast(ff.年度 as int)=t.年度 and cast(ff.期间 as int)=t.期间 and ff.指标名称=t.指标名称),0) as 金额
from
(
select distinct 账套名称,cast(年度 as int) as 年度,cast(期间 as int) as 期间,
case when cast(行号 as int)<10 then '0'+cast(行号 as varchar(10)) else cast(行号 as varchar(10)) end as 行号 , 指标名称
from FA_Value_Sunyi
where 账套名称 in ($(财务分析_账套名称))
and 指标名称 in ('营业收入','收入总额','营业成本','成本总额','期间费用','营业毛利','营业利润','利润总额','净利润')
and cast(年度 as int) =left('$(日期-年月)',4) and 期间>0
--and cast(年度 as int)*12+cast(期间 as int)<=year(getdate())*12+month(getdate())
and cast(期间 as int)<= right('$(日期-年月)',2)
)t
union all
select 账套名称,
cast(年度 as varchar(10))+'年' as 年度,
case when 期间<10 then '0'+cast(期间 as varchar(10))+'月' else cast(期间 as varchar(10))+'月' end as 期间,
case when 期间<10 then cast(年度 as varchar(10))+'年'+'0'+cast(期间 as varchar(10))+'月' else cast(年度 as varchar(10))+'年'+cast(期间 as varchar(10))+'月' end as 年度期间,
指标名称,行号+指标名称 as 行号指标,'累计金额' as 值类型,
isnull((select sum(本期本币金额) from FA_Value_Sunyi as ff where cast(ff.年度 as int) =left('$(日期-年月)',4) and ff.是否包含未记账='$(财务分析_是否包含未记账)' and cast(ff.期间 as int)>0
and ff.指标名称 in ('营业收入','收入总额','营业成本','成本总额','期间费用','营业毛利','营业利润','利润总额','净利润')
and ff.账套名称=t.账套名称 and cast(ff.年度 as int)=t.年度 and cast(ff.期间 as int)<=t.期间 and ff.指标名称=t.指标名称),0) as 金额
from
(
select distinct 账套名称,cast(年度 as int) as 年度,cast(期间 as int) as 期间,
case when cast(行号 as int)<10 then '0'+cast(行号 as varchar(10)) else cast(行号 as varchar(10)) end as 行号 , 指标名称
from FA_Value_Sunyi
where 账套名称 in ($(财务分析_账套名称))
and 指标名称 in ('营业收入','收入总额','营业成本','成本总额','期间费用','营业毛利','营业利润','利润总额','净利润')
and cast(年度 as int) =left('$(日期-年月)',4) and 期间>0
--and cast(年度 as int)*12+cast(期间 as int)<=year(getdate())*12+month(getdate())
and cast(期间 as int)<= right('$(日期-年月)',2)
)t