Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.