SSRS
i need to display the count of rows at grouoing level column has yes or No no values, i need to count the values when it is 'YES'
can anyone help me regarding this
I am using this one which doesn't work. =iif(Fields!OnTime.Value= "YES", count(Fields!OnTime.Value="Yes"),0)
July 22nd, 2011 1:34pm
try this
=Sum(iif(Fields!OnTime.Value= "YES", 1,0))
--------------------------------------------------------
Surender Singh Bhadauria
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2011 1:56pm
Thanks,
This helped me alot...
July 23rd, 2011 6:59pm
Mark as answer if it worked--------------------------------------------------------
Surender Singh Bhadauria
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2011 11:31pm