I want to calculate yield for line_name and line group over days/weeks/months/etc. Yield is calculated by dividing LBS PROD with line type 1 by LBS PROD with line type -1. I was able to accomplish this with a table calculation, however I want to do more calculations from this yield percentage.
For instance different machines (lines) have different acceptable yields so a huller might be ok running with a 75% yield, however a roaster must be above 89%. So I wanted to run a case statement so that I could color the bar charts by acceptable or not acceptable yields depending on their line group, however I have no idea how to make the calculation in the case statement
CASE [LINE GROUP]
WHEN "01-Roasters" THEN IIF(??????>89%, "Acceptable", "Not Acceptable")