Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
Pls help me to correct the following script. It does not show data as per slabs given in it. only first and last slab slow
if((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=10000 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10000, Dual('<=10000',1),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000), Dual('10,001-25,000',2),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=25001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=50000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-25001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-50000), Dual('25,001-50,000',3),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=50001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=500000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-50001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-500000), Dual('50,001-500,000',4),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=500000 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-500000), Dual('Above 500,001',5))))))As NET_RANGE_WO_RF
Hello!
Check these conditions:
((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)
AND
((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000)
and try OR instead AND
((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)
OR
((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000)