Thank you for responding. Project Number and Year are coming from two different tables. In front end if I want to create a table chart I a facing this issue.
I have tried the solutions which you have mentioned..still getting the issue.
In addition to this I have tried isNull function as well.
Check I have given 2 ways.
1. With If statement
2. To change the missing and null symbol from presentation tab of straight table.
Test.qvw 154.5 K