Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

NL(RowsUnique)

This is just a new keyword for something Jet already does.  New users have a lot of difficulty understanding the different results produced by Jet depending on whether or not they fill in the Field box.  If you want unique occurrences, you fill in the box, if you want all occurrences you don’t.

To give these new users credit, this really is two different behaviors and should be given two different names:  NL(Rows) and NL(RowsUnique)

  • Guest
  • Mar 31 2018
  • Under Consideration
  • Attach files
  • Gabriele Hayden commented
    June 22, 2018 21:21

    Agree that somehow improving the user experience to remind users of the difference between summary lists and detail lists/indicate when they are choosing which would be amazing, as new users in training often have a lot of difficulty with this.

  • Guest commented
    April 02, 2018 09:00

    Definitely a good idea, but i am not sure how this will work on existing reports with NL Rows Values though.

    So we basically will have two functions that do the same thing? NL Rows Values and NL RowsUnique.