Is averaging textboxt value possible

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Is averaging textboxt value possible

Is averaging textboxt value possible

Rate Topic

Display Mode

Topic Options

Author

Message

SSRSnewB

Posted Friday, December 14, 2012 12:43 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 6:31 PM
Points: 10, Visits: 33

Test results - Textbox header column in Table region
Pass - Textbox value
Fail - Textbox value
Fail - Textbox value
Pass - Textbox value
etc.
etc.

I have a textbox in the report header I want to add an expression something along the line

Count(Fields!Test.value) = Fail/Count(Fields!Test.value)=Pass

Post #1396786

Ray M

Posted Friday, December 14, 2012 1:17 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 1,468, Visits: 941

Do you mean you need to figure out the percentages?

%Fail
SUM(iif(Fields!Test.value="Fail", 1, 0)) / Count(Fields!Test.value)

%Pass
SUM(iif(Fields!Test.value="Pass", 1, 0)) / Count(Fields!Test.value)

Fail/Pass
iif(SUM(iif(Fields!Test.value="Pass", 1, 0)) <> 0, SUM(iif(Fields!Test.value="Fail", 1, 0)) / SUM(iif(Fields!Test.value="Pass", 1, 0)), 0)

Post #1396803

SSRSnewB

Posted Friday, December 14, 2012 2:34 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 6:31 PM
Points: 10, Visits: 33

Yes, Thank you very much.

Post #1396820

« Prev Topic | Next Topic »

Permissions