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.
Dean
No idea on the proper syntax for this, any assistance would be appreciated.
Dean
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