Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Sorry, From here what was the error you faced? What you are expecting to see
Script is ok to me
And even Formula is fine for me
IF (Classification <= 0.25 , '0-25%' ,
IF (Classification >= 0.26 and Classification <= 0.50, '26-50%',
IF (Classification >= 0.51 and Classification <= 0.75, '51-75%',
IF (Classification >= 0.76 and Classification <= 1, '76-100%',
'Null'))))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
you might be hitting rounding problems which your bucket statement may not handle. i would simplify the statement (as well as make it more reliable). In load script:
If(Classification <= 0.25 , '0-25%' ,
If(Classification <= 0.50, '26-50%',
If(Classification <= 0.75, '51-75%', '76-100%'))) as Class
This assumes that call values of Classification are between 0 and 1.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
