[Zope] Re: how to accumulate data using ZPT

2005-05-24 Thread prabuddha ray
ok this is again freaky on my part. my problem still remains intact .as i've told earlier, in my ZPT I needed to find a way to sum up column values if they are present and print the total at the last row. I tried this as a Deepak pal tipped : span tal:condition=not:penaltylen

[Zope] Re: how to accumulate data using ZPT

2005-05-24 Thread Deepak
What r those "penaltylen" and "penalty"? and also can u tell us y u r checking "not:penaltylen"? regards, Deepak prabuddha ray wrote: ok this is again freaky on my part. my problem still remains intact .as i've told earlier, in my ZPT I needed to find a way to sum up column values if

[Zope] Re: how to accumulate data using ZPT

2005-05-24 Thread prabuddha ray
sorry, i missed the xplanaition. i think this'll explain... div tal:define= penalty python:context.getPenalty(group_code=gcode,item_code=icode); penaltylen python:test(len(penalty)==0) so not:penaltylen ensures that unit_cost is present for this row. anyway i think this worked

Re: [Zope] Re: how to accumulate data using ZPT

2005-05-24 Thread Tino Wildenhain
Am Dienstag, den 24.05.2005, 04:09 -0700 schrieb prabuddha ray: sorry, i missed the xplanaition. i think this'll explain... div tal:define= penalty python:context.getPenalty(group_code=gcode,item_code=icode); penaltylen python:test(len(penalty)==0) so not:penaltylen ensures

[Zope] Re: how to accumulate data using ZPT

2005-05-21 Thread prabuddha ray
thanks that was creative and justified. BUT it didnt work. the total is still 0. here is what i did. div tal:define=unit_cost python:penalty[0].unit_cost; global sum python:0 tal:condition=not:penaltylen tal:content=unit_cost span tal:define=global sum

[Zope] Re: how to accumulate data using ZPT

2005-05-21 Thread prabuddha ray
sorry for the last mail. it was a simple tag order mistake . final version is : span tal:condition=not:penaltylen tal:content=python:penalty[0].unit_cost/ span tal:define=global sum python:sum+penalty[0].unit_cost/ trtdbTotal tdb tal:content=sum/b/td/tr plz be in touch it'll good for

[Zope] Re: how to accumulate data using ZPT

2005-05-20 Thread prabuddha ray
sorry for delay, but the options you gave are ruled out. actually not all the rows in the column have the values. further the total i'm looking for will result in a very complex query that i dont want to do onsidering the no. of rows are high. I just need something like a

Re: [Zope] Re: how to accumulate data using ZPT

2005-05-20 Thread Chris McDonough
Use two things: a page template and a Python script... here's an example: page template body -- div tal:define=L python: [1,2,3,4]; A python: context.sum_of(L) div tal:repeat=V L tal:content=V1/div div tal:content=Atotal/div /div python script

Re: [Zope] Re: how to accumulate data using ZPT

2005-05-20 Thread Tino Wildenhain
Am Freitag, den 20.05.2005, 03:54 -0700 schrieb prabuddha ray: sorry for delay, but the options you gave are ruled out. actually not all the rows in the column have the values. Which is perfectly met by the if statement. Please read _my_ post again and to the end. further the total