formula not calculating on first record

[menuch]

When I use this formula I get no data returned on the first groups first record.I do get it on the second record and so on. I will get it on the 2nd groups first record..

global numbervar R:={#Record Number};
global datetimevar S:={@63 - Date Time};
global datetimevar N:=previous({@98 - Date Time});

if R=1 Then datediff('n',{@DateTime - Out of Garage},{@63 - Date Time})
else

datediff('n',N,S)


Thanks!

 

[Ngolem]

You have 3 other formulas involved here that may be the problem....list them as well

But probably your problem relates to the fact that you are refering back to a previous value...which on the first record will be a null

if not ispreviousNull({@98 - Date Time})then
global datetimevar N :=previous({@98 - Date Time})
else
(put something here);



Jim Broadbent