Sum by condition

[pb100]

Using CRXI Developer and SQL 2005 Express, I am developing a chart. The ‘On change of’ is by time period. I have a set of events for each time period and each event has an event type. Event type can be one of 6 known values. I need to create a formula that will sum data by time period, by event type. The show values in the chart will be the data for each event type (data value1 for event type1, datavalue1 for event type2,… and data value2 for event type1, data value2 for event type2,…).

What is the formula for doing this?

 

[IdoMillet]

One option is to create 6 formulas, each looking like this:

IF {event_type}=1 THEN Value ELSE 0

Then, you can sum these values.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

If you use the advanced chart layout, you could use time period and event type as on change of fields.

-LB