Expression Issue

[jpjust]

Hi All,

Can some one please help me figuring out an syntax error on the below expression would be of a great help!

Or if there is another way of writing the same expression, please let me know.

IF(if(len(SUM(CEIL(Avail_S_Units/PP_Q))) =0,0,sum(ceil(Avail_S_Units/PP_Q))) >=If(len(sum(CEIL(Demand/PP_Q))) = 0,0,(sum(CEIL(Demand/PP_Q))-(sum(CEIL([Items Packed]/PP_Q))+ sum(CEIL([Items Shipped]/PP_Q))))),0,
IF(If(len(sum(CEIL(Avail_S_Units/PP_Q))) = 0, 0, sum(CEIL(Avail_S_Units/PP_Q))) < If(len(sum(CEIL(Demand/PP_Q))) = 0, 0, (sum(CEIL(Demand/PP_Q)) - (sum(CEIL([Items Packed]/PP_Q))) + sum(CEIL([Items Shipped]/PP_Q))))),((If(len(sum(CEIL(Demand/PP_Q)))= 0, 0, sum(CEIL(Demand/PP_Q)))) - (sum((CEIL([Items Packed]/PP_Q))) + sum(CEIL([Items Shipped]/PP_Q))))/*packages remaining END*/ - If(len(sum(CEIL(Avail_S_Units/PP_Q))) = 0, 0, sum(CEIL(Avail_S_Units/PP_Q)))))

[Vegar · Accepted solution]

A right paranthesis to much.  See my red markings below where I have commented out the paranthesis.

IF(if(len(SUM(CEIL(Avail_S_Units/PP_Q))) =0,0,sum(ceil(Avail_S_Units/PP_Q))) >=If(len(sum(CEIL(Demand/PP_Q))) = 0,0,(sum(CEIL(Demand/PP_Q))-(sum(CEIL([Items Packed]/PP_Q))+ sum(CEIL([Items Shipped]/PP_Q))))),0,
IF(If(len(sum(CEIL(Avail_S_Units/PP_Q))) = 0, 0, sum(CEIL(Avail_S_Units/PP_Q))) < If(len(sum(CEIL(Demand/PP_Q))) = 0, 0, (sum(CEIL(Demand/PP_Q)) - (sum(CEIL([Items Packed]/PP_Q))) + sum(CEIL([Items Shipped]/PP_Q))))/*)*/,((If(len(sum(CEIL(Demand/PP_Q)))= 0, 0, sum(CEIL(Demand/PP_Q)))) - (sum((CEIL([Items Packed]/PP_Q))) + sum(CEIL([Items Shipped]/PP_Q))))/*packages remaining END*/ - If(len(sum(CEIL(Avail_S_Units/PP_Q))) = 0, 0, sum(CEIL(Avail_S_Units/PP_Q)))))