Sum the Previous Dates info

[RichardLee]

Hi, I have a Data load that is randomly pulled to allow for Data checking.

I could pull the data today and then wait 3 weeks or 3 days to pull the next but I want to make sure that the previous numbers have changes to them.

so I have 

=SUM(if([Load Date]=today(),[Call Num]))

this works perfectly but I need a column next to it to show the previous Data no matter the age between the two dates?

how can I do this?

[vikasmahajan]

Max({<[Load Date]={"$(=date(Max([Load Date])))"}>} [Call Num])

&

Max({<[Call Num]={"$(=date(Max([Call Num],-1)))"}>} [Call Num])

Hope this helps

Vikas

[RichardLee]

This is a great help Vikas,

what if I also want to do the following 

Sum(if([Load Date]=today() and [Overdue Flag]='Overdue' and Days<>'1-5' and Days<>'6-30',[Value £]))