Expression Error

  • Hi geniuses,

    I'm having problems with a traffic light indicator expression:

    =SWITCH(

    ReportItems!Textbox21.Value="1.1.PC" and ReportItems!Textbox23.Value<>"",0,

    ReportItems!Textbox21.Value="4.2.PP" or "4.3.PE" or "4.4.S" and ReportItems!Textbox23.Value="",1,

    ReportItems!Textbox21.Value="1.1.PC" or "1.2.PV" or "1.3.PNV",2

    )

    The error: ...an error: Input string was not in a correct format.

    But if I only use:

    =SWITCH(

    ReportItems!Textbox21.Value="1.1.PC" and ReportItems!Textbox23.Value<>"",0,1

    )

    It works fine.

    ???

    Thanks

    Regrdas

  • ReportItems!Textbox21.Value="4.2.PP" or "4.3.PE" or "4.4.S" and ReportItems!Textbox23.Value="",1

    You got to change the above line to :

    (ReportItems!Textbox21.Value="4.2.PP" or ReportItems!Textbox21.Value="4.3.PE" or ReportItems!Textbox21.Value="4.4.S") and ReportItems!Textbox23.Value="",1

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • Hi I'm getting a warning error while rendering my report, it says that 'Input string was not in a correct format.'

    =SWITCH(

    ReportItems!Textbox70.Value="2.2.PA" and IsNothing(Lookup(Fields!ProjectGUID.Value, Fields!ProjectUID.Value, Fields!PBSD.Value, "DataSet3")),1,

    ReportItems!Textbox70.Value="2.2.PA" and Lookup(Fields!ProjectGUID.Value, FIelds!ProjectUID.Value, Fields!PBSD.Value, "DataSet3")="",2,

    ReportItems!Textbox70.Value="1.1.PC" or "1.2.PV" or "2.1.PS",3)

    It is for sure because, when I want to to know if Fields!PBSD.Value is = "" or not.

    Any solution?

    Thanks

    Regards

  • PLEASE REFER TO MY PREVIOUS POST...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • Anyway, it gives me the same error.

    Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

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