Sometimes a complex IF condition is needed.
Let's take and example, Assuming we have the following raw data:
|ItemID||Item Name||Item Status|
The Goal is:
Let's assume our business user ask to see which items are not approved and which are approved.
Pending items are considered as
IF Condition Example:
=IIF((Fields!ItemStatus.Value = "Tentative") Or (Fields!ItemStatus.Value = "Pending") ,"Not Approved", "Approved")