12,244,489 members (42,902 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 595 BillWoodruff 240 George Jonsson 228 Jochen Arndt 165 ppolymorphe 136
 OriginalGriff 555 BillWoodruff 240 Jochen Arndt 165 ppolymorphe 136 Kornfeld Eliyahu Peter 85