Putting Remarks above Average Score in Table in RD

2019-08-31 14:06发布

问题:

Hi i am trying to Compute the Average Score of all the evaluators and put the Remarks above the total average and i used Switch Statement to check it. if the Average Score is Strongly Agree,Agree,Disagree or Strongly Disagree

i think there is a problem in my Switch statement code please help the remarks is not accurate

Here is The Picture of my Reports

The Fields!ans1. Value have the average score

Here is my code in Determining if the remarks of Average Score is Agree,Strongly Agree or Disagree

  =Switch(
Fields!ans1.Value < 1.50, "Strongly Disagree",
Fields!ans1.Value > 1.74, "Disagree",
Fields!ans1.Value > 2.74, "Agree",
Fields!ans1.Value > 3.74, "Strongly Agree"

    )

回答1:

SOLVE ! . i used ReportItems!Textbox.Value instead of the Fields!ans1.value