No, all that does is print the number. What are you trying to do?
Thread Starter
vrapto
(@vrapto)
HI Xnau
I have different values in a field and would like to calculate them (SUM) based on a filter on four other fields.
agent_name option cost date_started
agent 1 standard 300.00 1 march 2013
agent 2 standard 300.00 5 march 2013
agent 1 active 900.00 2 march 2013
agent 2 active 900.00 1 march 2013
agent 1 standard 300.00 3 march 2013
agent 3 standard 300.00 4 march 2013
agent 3 standard 300.00 4 February 2013
agent 1 standard 300.00 25 February 2013
agent 2 standard 300.00 1 February 2013
I would like to list a report on each agent and total how much they must pay based on the month of March.
Cheers
vrapto,
Well, as long as you are not trying to store those numbers, it’s easy. You’re going to do a similar MySQL query, but for each record. Create a dummy field to give you a place to put the number, and then put code in your custom template to replace the value in the dummy field with your total. That code goes into the loop so it’s executed for every record. You’ll need to be confortable with PHP to make this work.
