Need help calculating in QUERY.
I want to calculate a column that will give me a planned production quantity for the shift.
I have the possible/maximum output in each shift. And I have total demand.
The goal is to split the demand into shifts.. possible between 1-3 shifts.
(In Excel the calculation simply activates a reduction).