[PLUG] Openoffice special formula...
Eric Wilhelm
scratchcomputing at gmail.com
Tue Aug 16 19:18:40 UTC 2005
# from plug_0 at robinson-west.com
# on Tuesday 16 August 2005 09:05 am:
>with one important gotcha. Transactions that are not cleared should
>not be included in the calculation. This is a dual input formula,
>yes/no on a row's information and a running sum of what's being
>added or subtracted.
OpenOffice has support for string comparison functions and conditional
statements. It's not pretty and you need to read the manual, but you
can essentially do something like:
$balance += (($cleared eq "*") ? $transaction : 0);
I know. Perl makes it look so easy! The formula's code *will* be
uglier.
--Eric
--
If the collapse of the Berlin Wall had taught us anything, it was that
socialism alone was not a sustainable economic model.
--Robert Young
---------------------------------------------
http://scratchcomputing.com
---------------------------------------------
More information about the PLUG
mailing list