overall percentage in report

• montu_patel_2005

  Newbie

  Points: 8

  More actions

  December 8, 2014 at 11:52 am

  #295670

  hi,

  i am trying to figure out how to get over all percentage not sure about the syntax which is what tripping me up.

  so i have 4 rows and they have this expression below if the course type is online then the first part become true else second part becomes true. now this express gives me a decimal and i have converted the text box to percentages and now i am trying to figure how if the first 4 have lets a percentages of 96.00, 88.00, 99.00 and 85.00 then how can i get an an average percentage for those 4 rows ?

  in my report i have a column that contains percentages but also has some text. will this expression be inside the column group or outside.

  =IIf(Fields!COURSETYPE.Value="Online",sum(Fields!OCQV1.Value)/(count(Fields!OCQV1.Value)*4),sum(Fields!ICQV1.Value)/(count(Fields!ICQV1.Value)*4))

  =IIf(Fields!COURSETYPE.Value="Online",sum(Fields!OCQV2.Value)/(count(Fields!OCQV2.Value)*4),sum(Fields!ICQV2.Value)/(count(Fields!ICQV2.Value)*4))

  =IIf(Fields!COURSETYPE.Value="Online",sum(Fields!OCQV3.Value)/(count(Fields!OCQV3.Value)*4),sum(Fields!ICQV3.Value)/(count(Fields!ICQV3.Value)*4))

  =IIf(Fields!COURSETYPE.Value="Online",sum(Fields!OCQV4.Value)/(count(Fields!OCQV4.Value)*4),sum(Fields!ICQV4.Value)/(count(Fields!ICQV4.Value)*4))