Hi,
I have the below iif statement within my expression. How can I take this further to perform further actions if the result is in fact "B"?
[code][/=IIf(
(
iif
(
Fields!MandateReference.Value Like "*85397"
OR Fields!MandateReference.Value Like "*85398"
OR Fields!MandateReference.Value Like "*85399", Fields!Local_Currency.Value," "
)
/
(
iif
(
Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00001"
OR Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00002"
OR Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00003",
Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!Local_Currency.Value, "d_ExcludedHoldingsGFS")," "
)
+
iif
(
(Fields!MandateReference.Value Like "*85397"
OR Fields!MandateReference.Value Like "*85398"
OR Fields!MandateReference.Value Like "*85399"), Fields!Local_Currency.Value," "
)
)
>= 0.5
)
OR
(
iif
(
(Fields!MandateReference.Value Like "*85397"
OR Fields!MandateReference.Value Like "*85398"
OR Fields!MandateReference.Value Like "*85399"), Fields!Local_Currency.Value," "
)
/
(
iif
(
Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00001"
OR Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00002"
OR Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!MandateReference.Value, "d_ExcludedHoldingsGFS") Like "*00003",
Lookup(Fields!MandateReportingName.Value, Fields!MandateReportingName.Value, Fields!Local_Currency.Value, "d_ExcludedHoldingsGFS")," "
)
+
iif
(
(Fields!MandateReference.Value Like "*85397"
OR Fields!MandateReference.Value Like "*85398"
OR Fields!MandateReference.Value Like "*85399"), Fields!Local_Currency.Value," "
)
)
<= 0.3
), "A", "B"
)code]
Thanks.