I'm not very familiar with Qlikview, but if you could provide a sample workbook and the output you're looking for I should be able to help with getting this calculation to work.
Off the top of my head other than the iif the only thing that concerns me is the quotient [LX_QTY]/[OP_RUN_STD] which would be computed on the disaggregated data. That may be what you want, but it is hard for me to be sure.
1 of 1 people found this helpful
The issue was that I was trying to change the formula of the existing "sum" syntax. It worked when I created a new calculation. Thanks for the response though!