Need help on Script

[paulwalker]

Hi Community,

Please could you explain below  script.. someone has made this..

IF(IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC', IF(Category='CAR',( Category *1),
IF(Category ='BUS',( Category *3.1),'')),'') as CategoryNew

Regards,

Paul

[Anil_Babu_Samineni]

Like way?

IF(IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC', IF(Category='CAR',( Category *1),
IF(Category ='BUS',( Category *3.1),'')),'') as CategoryNew

Blue part, Will understand the condition fulfill or not. That means, First it will effect to show OR operator then AND operator. If condition fulfill show ABC else Null. IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC' If this condition returns either ABC or Null. Then represent only ABC values. same as next one. You may bifurcate and do some analysis. Else, Ask use if anything not understandable.

[jfkinspari]

I think the Category field i Dual, so it consists of both a string and a number. That could explain why the formel uses both string and number condition on the same field

In the end it multiplies Catagory as with 1, if its a CAR, and if's a bus multiplied with 3,1.