Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is averaging textboxt value possible Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 12:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 8, 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
Posted Friday, December 14, 2012 1:17 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:29 PM
Points: 1,483, Visits: 1,031
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
Posted Friday, December 14, 2012 2:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 8, 2013 6:31 PM
Points: 10, Visits: 33
Yes, Thank you very much.
Post #1396820
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse