SSRS :如何对列的某些值进行聚合？

Question

我在SSRS中有一个列(比如PriceA)，它是基于表达式填充的。

PriceA.value

IIF((Fields!MOP.Value = "PRIV" OR Fields!MOP.Value = "FACI" OR Fields!MOP.Value = "GUAR" OR Fields!MOP.Value = "CASH"
OR Fields!MOP.Value = "CHRG" OR Fields!MOP.Value = "INV"), 

    IIF(Fields!UDRx.Value,"U/D",Fields!TtlPrice.Value), 

        IIF(Fields!elecadj.Value="0" AND Fields!elecadj2.Value="0", IIF(Fields!UDRx.Value,"U/D",IIF(Fields!MOP2.Value="0",Fields!Copay.Value,"")), 

            IIF(Fields!UDRx.Value,"U/D",Fields!PatientPayAmt.Value)
        )
    )

PriceA中的值可以是"U/D“，也可以是零，也可以是"150.00”。现在，我想在报告的末尾显示该列中行的聚合，丢弃值$0.0和"U/D“。

我该怎么做？

我还有另一列，它显示基于两个不同表达式的值，我需要聚合这些表达式。那个也没用。

2ndPriceA_expression

IIF((Fields!MOP.Value = "PRIV" OR Fields!MOP.Value = "FACI" OR Fields!MOP.Value = "GUAR" OR Fields!MOP.Value = "CASH"
OR Fields!MOP.Value = "CHRG" OR Fields!MOP.Value = "INV"), " ",

    IIF(Fields!elecadj.Value="0" AND  Fields!elecadj2.Value="0",

        IIF(Fields!UDRx.Value="0",Format(Fields!TtlPrice.Value,"C"),"U/D") , 

            IIF(Fields!UDRx.Value="0",Format(Fields!Payor1PaidAmt.Value,"C"),"U/D")
    )

)

2ndPriceB_expression

IIF(Fields!MOP2.Value<>"",
    IIF(Fields!elecadj.Value="0" and Fields!elecadj2.Value="0"
        ,IIF(Fields!UDRx.Value="1","U/D",Fields!Copay.Value)
        ,IIF(Fields!UDRx.Value="1"
            ,"U/D"
            ,IIF(Fields!elecadj2.Value="0"
                ,Fields!Copay.Value
                ,Fields!Payor2PaidAmt.Value
                )
            )
        )
," ")

我需要在第三单元中显示2 2ndPriceA和2 2ndPriceB的总和。抱歉，我刚来SSRS 2周。

提前谢谢。任何帮助都是非常感谢的。

Answer 1

只需对IIF()表达式执行SUM()，该表达式将过滤出不想求和的值。