Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Please Help me to find the error in following Expression.
If(ROUND(RANGESUM(SUM(IF(CAT='BR',(COM_PRE*BR_COM_ORC)/100,0)),
SUM(IF(CAT='AG',(COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC)/100,0)),
SUM(IF(CAT='GR',(COM_PRE*BR_COM_ORC)/100,0)),
SUM(IF(RANGESUM(BRO_ORC+AGE_ORC+GRO_ORC=0) and ORC_COM>0,((COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0)),
-SUM(CRE))) <0,
ROUND(RANGESUM(SUM(IF(CAT='BR',(COM_PRE*BR_COM_ORC)/100,0)),
SUM(IF(CAT='AG',(COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC)/100)),
SUM(IF(CAT='GR',(COM_PRE*BR_COM_ORC)/100)),
SUM(IF(BRO_ORC=0 and AGE_ORC=0 and GRO_ORC=0 and ORC_COM>0,ALT(SUM(COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0)),
-SUM(CRE))))
Finlay i tried the below one,
But still it is not working.
SUM(IF(RANGESUM(SUM(BRO_ORC),SUM(AGE_ORC),SUM(GRO_ORC))=0 and ORC_COM>0,((COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0)),
-SUM(CRE)))).
Priyantha.
Can you please break it into smaller pieces like first investigate value of below:
-SUM(CRE)))
one by one remove the lines to see where you get values, and then add them again.
OK..
By remaining line by line it was observed the bold and underlined parts makes the error.
//SUM(IF(RANGESUM(SUM(BRO_ORC),SUM(AGE_ORC),SUM(GRO_ORC))=0 and ORC_COM>0,((COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0)),
Please anyone can suggest something new instead of mine.
Can you replace the bold line with below:
IF(RANGESUM(SUM(BRO_ORC),SUM(AGE_ORC),SUM(GRO_ORC))=0 and ORC_COM>0,SUM((COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0)),
Dear Angad,
Even though i replace the part, status of the expression shows error in expression.
Thanks.
ohh sorry, you need to remove extra ) from right before comma.
IF(RANGESUM(SUM(BRO_ORC),SUM(AGE_ORC),SUM(GRO_ORC))=0 and ORC_COM>0,SUM((COM_PRE*ME_COM)+(SR*ME_RS)+(TC*ME_TC))/100,0),
Also failed. anyway thanks for the great help.
No Idea..........
Will try an other way
Thanks lot.
