Formula to add minutes from a datediff function 1

[johnstrang]

Hi,

I have what should be an easy question, but is proving difficult.
All I want is the sum of the minutes from this formula (@act_time):

whileprintingrecords ;
if PreviousIsNull ({HPD_ACTIONS.CASE_ID}) then 0 
else
(
if {HPD_ACTIONS.CASE_ID} = previous({HPD_ACTIONS.CASE_ID})
and (previous ({HPD_ACTIONS.GROUP_NAME}) = {?Team} )
then
DateDiff ("n",previous({@action_time}) , {@action_time})
)

The aim is to get the total amount of time spend on different cases by the team specified in the parameter {?Team}.

I have tried grouping on the field {HPD_ACTIONS.CASE_ID} but that made no difference.

If anyone can help it will my Friday so much better

Thanks,
John

 

[lbass]

Because you are using the previous function, you can't insert a summary, so instead you would use a variable. If you have no groups, then create two formulas:

//{@sumacttime} to be placed in the detail section:
whileprintingrecords;
numbervar sumacttime := sumacttime + {@act_time};

//{@display} to be placed in the report footer:
whileprintingrecords;
numbervar sumacttime;

-LB

 

[johnstrang]

Thanks LB - I just could not work out why I was unable to use a summary. I know that my function {@act_time} returned a number so I thought I should be able to apply a summary to that number.

I've already moved on to using a running total - thanks also for providing sample formulas

Best regards, enjoy the weekend!

John