The help file says this about the fractile function:
The function argument expressions must not contain aggregation functions, unless these inner aggregations contain the total qualifier.
So your complex aggragated sum is probably the cause the first expression doesn't work. If in your chart QTY is only a single value for a row, then a fractile can't be calculated. But it's impossible to tell without knowing the specifics. Can you share the qvw you're working on?
Hi Gysbert, thank you for the response. I cannot provide the qvw, but if it comes to creating a sandbox of the problem I will.
Previously in order to get the fractile to work, the application has been using a vb script macro, that evaluates the expression that is in the referenced column for the applicable rows, storing it, and then using that in the fractile equation to get the correct value.
Is there a way to do something similar, and instead of using a macro, somehow reference the column in-chart as a number as opposed to an expression? However, this cannot be done in the script, as the expression in the column gives different values based on certain inputs and selections.