Day by day calculation

[#1]

Hi All,

I have a table with the following fields: Brand, Post_Date, Count(Id). To each date I want to calculate the count of the previous day.  I tried several thing with no luck. I only managed to calculate for today()-several days.

See calculation below:

= count(TOTAL {<Post_Date = {"$(=Date(today()-9))"}>} Id)

I want to replace the Date(today()-9)) to something like Post_Date-1.

Any ideas?

Thx,

Hila.

[#2]

OK I think I understand what you mean and I will defiantly try it.

Thanks Gysbert!