If then condition in webi

[former_member334960]

Hi all,

I have a requirement where , if an employee has status both "Yes" and "No" then we need to show "Yes" only , otherwise show the value.

Data is as below.

Left side data shows the date and if the survey was taken by a user. For User 1 and User 2 , we have status as "Yes" and "No", in that case, we should not show "No" in the result. We should show only "Yes" status. For User 3 and User 4 , we have only "No" so we can show it as is.

Could someone please let me know how to fix this by showing only status=Yes if a user has status=Yes and status=No

Thank you

[ayman_salem · Accepted solution]

Define the following variable:

Status: =If ([Survey Taken] = "No" And Max([Survey Taken]) In ([Name]) = "Yes") Then 0 Else 1

then filter the table with Status=1

...

I hope this helps you.