Ignoring records when the particular rows of that column is null(blank)

[#1]

Hi All,

In the scheme list I want to display only those items where the scheme is available. Hope some one can help me out. I have also attached the sample document which i am working on.

[#2]

hi boss,

please Edit that expression

=

if(len(schemes)<>0,schemes

)

[#3]

Yes Boss! 🙂 It works perfectly. By the way i have added rtrim to it as blank rows with blank scheme also displayed with it. But not sure whether the space is really there or not. So I used the rtrim with the expression. And i hope it works perfectly now!

=if(len(rtrim(schemes))<>0,schemes)