Not sure what you're connecting to in terms of data source, but my experience has been, if you're connecting to certain types of DB's the PERCENTILE function is not available unless you perform an Extract first. Then it will be available to you. Hope that helps? Thx, Don
Don is correct - Percentile and some other functions need to look at data at the record level - if the data is live and coming from some d/bs those functions will not be available
so -if you can try extracting the data - the record level calculations will then be available
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Yep forgot when I replaced the data source to mark the new one as an extract. Thanks.