SUM() x 2 Condition..??

[dafty]

can the "SUM()" function have 2 condition to grouping...

----------------------------------
[daftywork : work 4 everyone.]
>>

http://dafty.tk/

 

[synapsevampire]

Please post what you're trying to do, perhaps someone can
then help.

From CR help:

Count({orders.ORDER AMOUNT}, {orders.ORDER DATE}, "monthly&quot

Counts the number of orders in each group of orders in the Amount field (the total orders for each month). The orders are separated into groups whenever the value in the Date field changes to a new month.

DistinctCount({orders.CUSTOMER ID}, {orders.ORDER DATE}, "weekly&quot

Counts the number of different customers contacted, follow up contacts are excluded. Customers are separated into groups whenever the value in the Date field changes to a new week.

The following example is applicable to Crystal syntax:

(SummaryFunction({orders.ORDER AMOUNT}, {orders.ORDER AMOUNT}, "monthly&quot) % (SummaryFunction({order.ORDER AMOUNT}))

Groups values in the Amount field by month, summarizes the values for each month group, and shows those values as a percentage of the summary value for the entire report.

-k