12,824,299 members (43,328 online)
Rate this:
See more:
Hi

I am trying to combine two different IIF expressions as one. Is that possible by using "and"?? and I dont want to concatenate it. Any suggessions??
Posted 13-Dec-12 3:38am
@AmitGajjar 13-Dec-12 8:40am

what you mean by concatenate ?
Member 9581488 13-Dec-12 9:16am

You can try the following
=IIf(Parameters!MyField1.Value="Month" And Parameters!MyField2.Value="Sale",
Iif(Sum(Fields!Total.Value) = 0, "Zero sum", "Non-zero sum"),
"Test")
ryanb31 13-Dec-12 10:16am

You should post that as the solution. Good job.
Member 9581488 13-Dec-12 10:38am

Thank you!

Rate this:

## Solution 2

```You can try the following
=IIf(Parameters!MyField1.Value="Month" And Parameters!MyField2.Value="Sale",
Iif(Sum(Fields!Total.Value) = 0, "Zero sum", "Non-zero sum"),"Test")```
v2

Top Experts
Last 24hrsThis month
 OriginalGriff 175 ppolymorphe 135 CPallini 120 AnvilRanger 110 Karthik Bangalore 95
 OriginalGriff 5,262 Graeme_Grant 3,862 Karthik Bangalore 3,621 ppolymorphe 2,679 Jochen Arndt 2,611