Skip to content
+1-888-319-3663

COMMUNITY FORUM

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.


Dean
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
http://msdn.microsoft.com/en-us/library/sh9ywfdk(v=vs.80).aspx

Regards,
Ken

Answers
Best Answer
Chris Hanson answered 9 years ago
Marking as answered.

H

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