Skip to content


Creating simple calcuation field

dmitchell asked 9 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 9 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 9 years ago
Marking as answered.


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