[pmwiki-users] Calculations

[pmwiki at 911networks.com]

On Fri, 1 Dec 2006 16:18:16 -0000
marc <gmane at auxbuss.com> wrote:

>  said...
>  
> > I need to do a table with logical calculations. These values come
> > from an internal website. I could get these values through some
> > perl script.
> > 
> > || Value 1|| Value 2|| Value 3|| Value 4|| if Value1 > Value2 then
> > 'Value 2 + Value3' or if Value1 - Value2 <= 0 then Value 3 or...
> > 
> > I have 11 conditions (ifs). A case statement would be even better.
> > 
> > The other things is the next day, the new day's value would become
> > the 1st row, and the last 20 or 30 rows would be below.
> > 
> > It's almost like a very simplified spreadsheet. How can I do
> > that? 
> 
> See if this helps:
> 
>   http://www.pmwiki.org/wiki/Cookbook/PageVariableExtensions
> 
> otherwise, I guess we should build something.
> 
1. I just looked at it. It's a good start but is there a way of doing
a case statement? I have 11 ifs.

2. Is there a way of addressing the rows & columns of a table? and
say like:
if (R2C1 > R2C5) or (R2C1+R2C3 > R2C6) or (R2C2 > R2C7) ... then 'Yes' else 'No'


-- 
Thanks
http://www.sqlhacks.com
The SQL knowledge base