I am trying to create a BAQ that will summarize job and labor dtl data by part numbers. I am fairly well versed in creating BAQs and I understand SQL for the most part but I do not have access directly editing SQL.
I want to aggregate data for example to find the median job qty, quartiles, and standard deviation, for a given part number. I was trying to play around with the PERCENTILE_CONT function and epicor doesnt seem to reject the syntax but I am missing something.
As i understand it SQL syntax generally doesn’t have a function for median and i know Epicor doesnt have it in the fucntion editor. Not sure about if there is an easy way to aggregate standard deviation as well.
It has to be pretty common that users need to aggregate by more that just your standard avg, sum, min, max, etc. Hoping someone can shed some light on this!