1

I am trying to compute the following expression with Field calculator. The input table values are around the size of this value: 562643580,7843, and the field name (the field of destination) is: double, precision=20, scale=20:

([Sum_Pri_17]*0.0669)+(([Sum_Pri_18]-[Sum_Pri_17])*0.0551)+(([Sum_Pri_19]-[Sum_Pri_18])*0.0306)

The destination field should therefore not be too short. When doing the calculation, no result is computed and no error appears either.

I thought the expression was too long, so I tried to compute the following:

[Sum_Pri_17]*0.0669

The calculation's result was the same: no result is computed and no error appears either.

What am I doing wrong? Thank you for your help!

  • 3
    did you try and change your precision and scale, a scale of 20 means 20 decimal places and precision is a width of 20 – user681 Dec 24 '13 at 16:34
1

Try using python instead of VB. Error 000989 'Tool CalculateField cannot use VB expressions for service' happens with VB, but python runs okay when using the Calculate Field tool.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.