[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