How do I get the sum to work on a variable I created?

building reports desktopintelligence
1

I created a variable =Sum(If <= 15 Then 1 Else 0)
Minutes to resolve is calucated by taking the date and time the alert was resolved and then subtracting the alert date from my Ingres database (sum(int4(Interval(‘min’,ias.alert_history.resolve_date - ias.alert_history.alert_date))). My report is then grouped by division. My problem is that if I take alert date off the report I can not get the variable to give me a sum based on division.

aduncan (BOB member since 2004-07-19)

2

Try hiding the alert date coluimn in the table.

JaiGupta (BOB member since 2002-09-12)