August 26, 2008 at 8:25 am
I have a table with three columns of data that collectively needs to be averaged. My current expression string is this, which is obviously incorrect:
="Average Tube Weight: " &
format(avg(fields!Wt_Tube1.value) + avg(fields!Wt_Tube2.value) + avg(fields!Wt_Tube3.value) + avg(fields!Wt_Tube4.value), "#.##")
Because I do not want the averaged values added together. If I changed those to SUM and then averaged that - maybe that would work, but nope that didn't work because aggregate functions cannot be nested inside of other aggregate functions.
August 28, 2008 at 2:03 am
="Average Tube Weight: " &
format(avg(fields!Wt_Tube1.value) + avg(fields!Wt_Tube2.value) + avg(fields!Wt_Tube3.value) + avg(fields!Wt_Tube4.value), "#.##")
Have you tried using:
="Average Tube Weight: " &
format(avg(fields!Wt_Tube1.value + fields!Wt_Tube2.value + fields!Wt_Tube3.value + fields!Wt_Tube4.value), "#.##")
Regards,
Nigel West
UK
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply