I am trying to create a simple bar chart of normalized reject quantities for different reject event names. I have all of the data in a single table. Columns are OutputQty, RejectQty, RejectName, and Equipment. Sum(RejectQty) works fine. Sum(OutputQty) also works fine. I have tried multiple version with the aggr function, but I cannot get any version of the Sum(RejectQty)/sum(OutputQty) to work. The reject qty values are null, when the output quantity values are not missing, and the output qty is null, when the reject values are not missing.
I'm not sure if there is any aggr() needed. Just try it with:
Sum(RejectQty)/sum(OutputQty)
without an aggr(). If this doesn't returned the expected values then transfer all dimensions and expressions into a table-chart. Usually it's much easier to detect the issues within the data and/or the logic as within any graphically chart.
