CODEWITHSUNDEEP
ssrs-2008reporting-services
Arvindkoomarsing Balluck
Arvindkoomarsing Balluck

Reputation: 11

Count if SSRS in textbox

I have a scenario where I need to calculate a percentage based on - No of records with a certain value/ Total no of records. This is going into a textbox in the header. I am trying the following but I keep getting an error saying "Argument not specified for parameter FalsePart of Pulbic Function Iif.

Can anybody shed some light on this please?

=Count((Iif((Fields!Confirmed.Value, "KPI_Calculation")= True,1,Nothing)),"KPI_Calculation")
/Count(Fields!Confirmed.Value, "KPI_Calculation")

Thanks.

Upvotes: 1

Views: 6310

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

This worked for me in a simple test:

=Sum(IIf(Fields!ConfirmedValue.Value, 1, 0), "KPI_Calculation") / CountRows("KPI_Calculation")

It looks like in your above example you're declaring a Scope too many times and hence getting a syntax error.

Upvotes: 3

Related Questions