hel in formula -CR 8.5
Hi!
I have a report with sale lines grouped by date. Every line has the ClientCode, Kilos, Price, and LineTotal.
The question is as follows: How is the formula that I need use to have the Kilos sum just for the customers with ClientCode 9000 in every date group.
Would be possible perform this without a formula?
Thanks in advance
[362 byte] By [
lunero] at [2007-11-20 7:38:45]
# 1 Re: hel in formula -CR 8.5
You need to create a running total 'Client_9000'.
In a field explorer, right click on 'Running Total Field'.
For 'Field to summarize -> select an add the 'table.Kilos' field.
Type of summary -> sum.
Evaluate -> check 'use a formula', ->x+2 and enter following formula:
{table.ClientCode}=9000
reset -> on change of group {Group #n:table.date}
Place it in it's group footer.
good luck! :wave:
SvB_NY at 2007-11-9 14:09:22 >
