Thread: For each, if and if not statements?

Hello everybody,

I am brand new to SSRS and am having some issue finding out how to constuct logical statements and was wondering if you all had any idea. First off my statement that I need to construct will consist of the following:

For each item where status = "Inactive"

If resultA = "No" then a specific cell = Value 1 + Value 2 + Value 3 * Percentage

If resultA = "yes" then do not include a payment amount (already calculated)

Result of either items is then divided by a number (already calculated) to get a percent(%)

I hope I explained this well enough and hopefully can get some feedback on how to setup this formula. Thanks in advance for your help!

I believe the IIF statement would work for you. Here's an example that I use in the background color property for alternating colors:

Code:

=iif(rownumber(nothing) mod 2 = 0,"lightGrey","white")

Your code might be something like this:

Code:

=IIF(Fields!status.value = Inactive, "0", (Fields!value1.value + Fields!value2.value + Fields!value3.value) * Fields!Percentage.value)

Of course this assumes that all your values are in fields within the dataset you are working in.

If the result of this can be zero or null, keep in mind that you do not want to then divide the result by anything because you will get a divide by zero error.

Give this a try and let me know if you have any further issues with it.