December 8, 2014 at 11:52 am
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))
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply