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.
=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.