Visual Basic Crystal Reports - Help summarising a formulae

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Help summarising a formulae

Kedge

2006-03-16, 7:00 pm

Hello

I am using Crystal Pro V10

I've written the following formulae to calculate the difference (in
mins)between the datetime in one row and the datetime in the previous
row.

tonumber(if ({@numb} =3D 0) THEN
(datediff("n",(previous({SHR_Audit.Create_Date})),{SHR_Audit.Create_Date}))
ELSE 0 )

This is where {@numb} alternates 0 and 1 each other row, eg:

row number @numb
1 1
2 0
3 1
4 0
..=2E.... ........

This forumlae works and I get the figures I was expecting, however I
cannot summarise this column. I need to sum all the figures generated
from this formulae.

But when I go to the =ABInsert Summary=BB button, I am not given this
forumlae as something I can summarise.

Any ideas?

Cheers

kedge

Sponsored Links