1 Reply Latest reply: Jan 29, 2017 7:03 AM by Stefan Wühl RSS

    Filter Chart Expression Sum(If(Name='J*',1,0) Doesn't Work?

    Richard Ouellette

      Good Morning

       

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

       

       

      Thank!

       

      Rick