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
|
