casewhen [report].[XXCARD_STAT_2].[TYPE]='5' then cast(_round([report].[XXCARD_STAT_2].[发卡量]*100,2),varchar(10))+'%'else [report].[XXCARD_STAT_2].[发卡量]endcognos报错:语句中存在不兼容数据类型发卡量字段中存的是带小数数字...
显示全部case
when [report].[XXCARD_STAT_2].[TYPE]='5' then
cast(_round([report].[XXCARD_STAT_2].[发卡量]*100,2),varchar(10))+'%'
else [report].[XXCARD_STAT_2].[发卡量]
end
cognos报错:语句中存在不兼容数据类型
发卡量字段中存的是带小数数字
收起