The formula is a bit complicated so I haven't done a deep dive but this problems sticks out. You have references in your formula to another table:

COLUMN(tblPRODUCTION[@SUN2]
COLUMN(tblPRODUCTION[@SAT2]

but all of the SUN2 and SAT2 values in that table are 0, so COLUMN returns #VALUE! which propagates upwards. This is true for all SATx and SUNx references, which appear in various forms in many of your formulas.