Skip to Content

Null values for columns with similar formula - webi report

hi Gurus,

I want to display "payable currency" and "receivable currency" in 1 row as in pic1, I am using the below formula:

payable currency = [Currency] Where([P/R Flag] = "P")

receivable currency = [Currency] Where([P/R Flag] = "R")

When i use the above formula null values are getting displayed in alternate rows, can I know the way hide null values shown in pic2.

Thanks in advance

pic1.jpg (23.0 kB)
pic2.jpg (29.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 12, 2017 at 09:44 AM

    payable currency = if ([P/R Flag] = "P") THen [Currency] Else ""

    Add comment
    10|10000 characters needed characters exceeded