Home Forums Reporting Services Reporting Services SSRS Indicators Expression RE: SSRS Indicators Expression

  • September 21, 2012 at 5:16 am

    #1540591

    Try this instead

    missed a few , and " out

    =SWITCH

    (

    LAST(Fields!Value.Value, "DataSet1") = 0, "White",

    FIRST(Fields!Value.Value, "DataSet1") >= LAST(Fields!Value.Value, "DataSet1"), "Green",

    (FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) >= 0.7, "Yellow",

    (FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) < 0.7, "Red"

    )