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?
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.