Expression Issue

jpjust — Thu, 19 Aug 2021 19:23:36 GMT

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)))))

Re: Expression Issue

Vegar — Thu, 19 Aug 2021 20:48:30 GMT

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)))))

topic Re: Expression Issue in App Development

Expression Issue

Re: Expression Issue