0

I have written an expression like below ,but it is showing some error ,can any one help me with this....

=IIf(Parameters!Plan.Value=="all",IIf(Fields!Plan.Value=="freedom",count(Fields!No_Of_Admissions.Value),0), 0)

Thanks in Advance.

harish
  • 5
  • 3

1 Answers1

0

Take a look at This.

Without much detail I'm thinking you want to do something like this.

=IIF(Parameters!Plan.Value="all" AND Fields!Plan.Value="freedom", count(Fields!No_Of_Admissions.Value),0)
Community
  • 1
  • 1
NewGuy
  • 1,020
  • 1
  • 9
  • 24
  • thank you for your reply ..actually your expression is error free, but still i am not getting the required result... – harish Feb 08 '16 at 14:59
  • What is your goal for the expression? – NewGuy Feb 08 '16 at 15:02
  • Thank you ,now its giving result,,but as per my requirement city count delhi 23 jaipur 6 delhi 12 delhi 3 here i want sum(count) when city delhi selected the result should be delhi=38 – harish Feb 08 '16 at 15:34