holdsworthbros
asked on
Summarize excluding suppressed values
Hello,
I have a formula which adds two numbers (Call this field @Electronic). These numbers then have a (sum) summary created from them (@Electronic for a given day, selected by date). I have suppressed some values (duplicates), but the summary includes the suppressed values. Is there any way of asking the program to exclude suppressed values?
I have tried inserting the suppression formula into the ElectronicPayments formula (this formula compares the order number from this record, to the previous record and returns 0 if they are the same)
If (Previous({orderhea.ORDER_ NUMBER}) = {orderhea.ORDER_NUMBER})
Then 0
Else {paydetls.CREDIT_CARD}+{pa ydetls.EFT POS}
But then I cant summarize the field anymore! (Error: This field cannot be summarized) ARGH!
I even tried a running total, with the formula and it didnt work.
Can you help?
I have a formula which adds two numbers (Call this field @Electronic). These numbers then have a (sum) summary created from them (@Electronic for a given day, selected by date). I have suppressed some values (duplicates), but the summary includes the suppressed values. Is there any way of asking the program to exclude suppressed values?
I have tried inserting the suppression formula into the ElectronicPayments formula (this formula compares the order number from this record, to the previous record and returns 0 if they are the same)
If (Previous({orderhea.ORDER_
Then 0
Else {paydetls.CREDIT_CARD}+{pa
But then I cant summarize the field anymore! (Error: This field cannot be summarized) ARGH!
I even tried a running total, with the formula and it didnt work.
Can you help?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
I would post it as a new question rather than a comment to mine. It may not get answered otherwise.
I couldnt believe that there wasnt some simple way to tell Crystal to exclude supressed values! But it seems quite complex.
I would post it as a new question rather than a comment to mine. It may not get answered otherwise.
I couldnt believe that there wasnt some simple way to tell Crystal to exclude supressed values! But it seems quite complex.
OK Thanks!
I've got a similar issue here:
I 've got a report where I'm printing a qty for example
Order qty
100 1
103 2
etc.
I'm using a formula to suppress certain records - so that for instance in this case the reocrd for 101,102 are suppresed.
I would like to get the total qty without the suppressed records. In this case my toal would be three.
When I run running totals, sums - it will add the qty's of my suppressed records! What can I do?
Thanks!