Newbie on arithmetic - help request on arithmetic operation

batuco9 · Post by **batuco9** » Sun Sep 14, 2003 4:11 am

Is there any way to take a field and do arithmetic operaitons on it? Specifically, I want to take the inverse (1/x) of number in a given field.

Since one of the filters indicates that external programs may be invoked, can Window's "calc.exe" program somehow be invoked to calculate the inverse? Do the java or visual basic scripts allow for such a possiblity? If so, how could it be done?

By the way, I already got the formats down to csv.

Many thanks,
batuco9

Post by **DataMystic Support** » Fri Oct 03, 2003 5:34 am

Hi there,

Use a 'restrict to CSV field' to choose the data field first.

Then add a VBScript subfilter to calculate 1/x of the data and output it.

Have a look at the VBScript help and samples to see how this works.