Newbie on arithmetic - help request on arithmetic operation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Sun Sep 14, 2003 4:03 am

Newbie on arithmetic - help request on arithmetic operation

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,

User avatar
DataMystic Support
Site Admin
Posts: 2238
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

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.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads

Post Reply