Skip to Content
0

WEBI FORMULA TO COMPARE COLUMN VALUES

May 17, 2017 at 11:21 AM

41

avatar image

I HAVE COMPANY CODE and COUNTRY columns in a WEBI report when COMPANY CODE and COUNTRY values equal to 'NOT APPLICABLE'I WANT TO SHOW RESULT OF COLUMN XYZ COLUMN VALUES 'EMPTY' ELSE

RESULT OF COLUMN XYZ SHOULD BE AS IT IS PLEASE LET ME WEBI FORMULA TO ACHIVE IT

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
nutty buddy May 22, 2017 at 12:24 AM
0

=if([COMPANY CODE] = "NOT APPLICABLE") OR ([COUNTRY] = "NOT APPLICABLE") then [XYZ] else " "

Share
10 |10000 characters needed characters left characters exceeded