Post reply

Help with a nested IIF

  • August 27, 2010 at 8:27 am

    #228376

    Code below is receiving error of : [rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox17’ contains an error: [BC30198] ')' expected.

    Build complete -- 1 errors, 0 warnings

    Where am I missing a ) ?

    =Iif((SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) <> 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0)

    ((Iif(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) = 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0))

  • September 9, 2010 at 12:35 am

    #1218390

    Iif((SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) <> 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0)

    ((Iif(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) = 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0))

    In the above code I assume that , the following is first part and the remaining is second part. There is no operator between these two.

    Iif((SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) <> 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0)

    I assume that the operator * between these two. And there is an unclosed opening bracket in the first part, same issue in the second part also. The code can be rewritten as ,

    Iif(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) <> 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0)

    *

    Iif(SUM(Fields!Percent_Met_Deployment_Complete_Target.Value) = 0,

    (SUM(Fields!Percent_Met_Deployment_Complete_Target.Value * Fields!Count_Equipment_Delivered.Value) /

    SUM(Fields!Count_Equipment_Delivered.Value)), 0)

    SQL Sever Performance tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply