Re: [pilot-db-list] calculated Script (Parameshwara Tunga)

[Michael L. <mic...@ig...>]

19/8/2006 21:58:02

>   1=2E calculated Script (Parameshwara Tunga)

>Dear Sir
>  I tried my best to use calculated in my applications=2E I am unable to =
find 
>the help on this point=2E Will you please help on how to write for 
>multiplications and previous  operations=2E
>  example  in other cases Cost =3D Quantity and Price ( Only Examples whe=
re 
>Quantity and Prices are floats and Cost is Calculated)=2ECan you please s=
end 
>me scripts example for mathematical operations or is there ant maths=2Epr=
c?=2E=2E
>  Thanking you
>  tunga

Formulae are LISP-like (check on LISP syntax): (operator variable1 variabl=
e2 etc=2E=2E=2E)

Example: Cost =3D Quantity x Price would be: ( * Quantity Price)

Example: 1 + 1: (+ 1 1)

** IMPORTANT: First column in Database is column 0 (zero), second is 1 (on=
e), etc=2E **

Example:

Column 0 =3D quantity - select field type FLOAT or INTEGER
Column 1 =3D Price - select filed type FLOAT
Column 2 =3D calculated cost - select field type CALCULATED

So, in Column 2 (the THIRD COLUMN), select field type CALCULATED, and ente=
r the formula: (* %0 %1)

(that means multiply the value in column 0 by the value in column 1) 

That's it=2E

Regards,

ML