Visual Studio函数IIF

q43xntqr 于 2023-10-23 发布在其他

关注(0)|答案(1)|浏览(121)

我使用Visual Studio 2017，我有这样一个表达式：

=Microsoft.VisualBasic.Strings.Trim(Fields!QUESTION.Value) & 
   " Average:" &
    ROUND(AVG(fields!Multiple_Choice_Value.value), 2) &
    "(Range"  &
    Min(Fields!Multiple_Choice_Value.Value) &
    "- " &
    Max(Fields!Multiple_Choice_Value.Value) &
    ")"

输出为“Procedures Average:85(Range 85-100)
我需要修改这个代码：如果Multiple_Choice_Value为空，则输出将仅为Not Observed

visual-studio

来源：https://stackoverflow.com/questions/77331849/visual-studio-function-iif

1条答案

按热度按时间

pqwbnv8z1#

也许是这样：

=IIF(Fields!Multiple_Choice_Value.Value Is Nothing, "Not Observed", 
    Microsoft.VisualBasic.Strings.Trim(Fields!QUESTION.Value) & 
       " Average:" &
        ROUND(AVG(fields!Multiple_Choice_Value.value), 2) &
        "(Range"  &
        Min(Fields!Multiple_Choice_Value.Value) &
        "- " &
        Max(Fields!Multiple_Choice_Value.Value) &
        ")"
    )

赞(0）回复(0）举报 2023-10-23

我来回答

Visual Studio函数IIF

1条答案

相关问题

热门标签

最新问答