代码改变世界

随笔分类 -  Reporting Services

Reporting Services表达式

2014-03-27 14:11 by 河水, 177 阅读, 收藏,
摘要: 当遇到需要相除的逻辑处理时,假设除数可能为0,那么首先使用IFF判断除数是否为零,并且在做相除的操作时,还需要设置除数如果为〇,给它一个默认值IFF(除数=0,"0",被除数/IIF(除数=0,1,除数))=IIf(Sum(Fields!baoming.Value, "network_name")=0,"0",FormatPercent(Sum(Fields!baoming.Value)/IIF(Sum(Fields!baoming.Value, "network_name")=0,1,Sum(Fields!bao 阅读全文