Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Where is your qvf?
.
.
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'))))
.
.
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.
.
Is that your complete load script?
.