Hello Nalin Mishra,this result set limit parameter was introduced to avoid crashes on front end side utilizing all memory on your laptop.Using a 64-Bit Office (and 64-Bit AfO) with 32 GB RAM I tested this parameter in a test environment:It still work...
Hello Justin,I can not tell which result is right or wrong. In your first example 12 data records (including the 0 values) are used to calculate the average: In the universe: 475 / 12 = 39In Design Studio the data records with 0 values are not ...