HOw to add count to 2 lists into third list.

[dgrover]

HOw to add count of two lists.

I have 3 lists in a page, say list a , list b , list c.

I am showing count of rows in list a and list b into list c.

Rows are fetched in list a and b as per the values prompted by the user.


List c shows correct result if list a and list b fectch some rows.

But if any one of list a and b is empty list c also goes blank.

Can anyone suggest me some way of resolving this issue.

I need a suggestion how to display 0 when list is empty?

[MDXpressor]

Calculating with a Null is kind of like multiplying by zero, any calculated result with a Null in the set becomes Null.  Try using an if...then...else statement to change the Null to a value even if the value is a space.