Forum Discussion
Count based on 2 tables
Hi All, Req: I have 2 tables ,I wanted to count fruits which has 1 or more fruits then count as 1 , if no fruits display as 0 and also grand total also required please don’t use any visual ...
What about the values in Fruits column that are not fruits e.g. first & second, AAAAA. Do you need to count those as fruits as well? If not, is there another list of valid values for Fruits that you have?
please consider first ,secound,AAAA etc.. are also fruits