Hello,I have question, how to sum rows. I create query =avg(iif(filds!urgency.value=1 and filds!_time<=14,1,iif(filds!urgency.value=2 and filds!_time<=130,1,0)), everything is ok, but I must sum average of average. When I sum row I get 93.33, but correctly score is 97,50%.

Never average averages unless the sample sizes of all elements are identical

The reason

suppose you have a set of average speeds for traffic along a roadJanuary 30mphFebruary 45mphMarch 15 mph

What is the average speed for the quarterYou cannot tell as you do not have sufficient information - you might think its (30+45+15)/3 = 30That is highly unlikely to be correct - for two reasons1 you don't know the sample sizes2 speeds are ratios

Now suppose you know that you haveJanuaryVehicle a 10 miles at 30 mphVehicle b 5 miles at 30 mphvehicle c 25 miles at 30 mph

When I used =SUM(CAST(ReportItems!Textbox13.Value AS INT) ) I get the message "The Value expression for the textrun 'sum.Paragraphs[0].TextRuns[0]' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers".