I have a simple chart with 1 expression above trying to tabulate 1st name counts based on the 1st Initial; typical 1st name fields are John, Jane, Susan, Linda, Richard etc. Can you suggest work around? I also need to filter using Sum(If(Name<>'J*',1,0).
As an FYI Sum(If(Name Like 'J*',1,0) works but I still would not have a solution for Sum(If(Name<>'J*',1,0).
Please don't post the same request multiple times, and also please post it to places with an appropriate scope (QDF probably is not a place with a correct sope)