Skip to Content

WEBI FORMULA TO COMPARE COLUMN VALUES

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 22, 2017 at 12:24 AM

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

    Add comment
    10|10000 characters needed characters exceeded