Skip to content


Creating simple calcuation field

dmitchell asked 10 years ago
I simply want to do a calcuation of one field divided by another field X 100 to get a percentage.

No idea on the proper syntax for this, any assistance would be appreciated.

KenHepworth replied 10 years ago

Hi Dean,

In VB which is the default for your calculated field, it would look like this

dim pctresult as decimal

pctresult = (_Field1 / _Fields2) * 100
return pctresult

the first line is the declaration of your result field and _Field1 and _Field2 are the values that you are using that would be source columns

I hope this helps. If need be go to the following link on basic syntax for VB


Best Answer
Chris Hanson answered 10 years ago
Marking as answered.


If you would like to submit an answer or comment, please sign in to the eOne portal.