SSRS Percent Calculation Formula 1

[aztech]

I am trying to calculate the percentage of attrition for our group business and I only need to see the ones that did not pick up their contracted room nights. Here's what I have:

=IIf(Fields!PickedUpGuestrooms.Value) < (Fields!AgreedGuestrooms.Value),(Fields!PickedUpGuestrooms.Value)/(Fields!AgreedGuestrooms.Value)

I also tried this:
=IIf((Fields!PickedUpGuestrooms.Value)<(Fields!AgreedGuestrooms.Value)),(Fields!PickedUpGuestrooms.Value / Fields!AgreedGuestrooms.Value)

I keep getting "wrong number of arguments" error. I tried different variations, but with no luck.

Thank you for any help you can give me.

 

[RiverGuy]

The IIf function works like this:

=Iif(Logical Test, Value If True, Value If False)

So you will need to specify your value if false. If you want to use a 0, then your code would look like this:

=IIf(Fields!PickedUpGuestrooms.Value < (Fields!AgreedGuestrooms.Value),(Fields!PickedUpGuestrooms.Value)/(Fields!AgreedGuestrooms.Value), 0)

 

[aztech]

Thank you! That worked perfect. I'm new to SSRS, so your help is greatly appreciated.