How to compare last date price?

[Anonymous]

Dear all,

i need an expretion for this scenario,

i want to compare the latest purchase price with last purchase date.

Eg:if product purchase date is 12/2/2010 with price is 12000,

                  last purchase date 5/2/2010.with price is 50000,

thanks

arunreddy

[pover]

arunreddy,

Here's one way to do it.  You should add 2 columns to the data model that contain the last and 2nd last purchase dates that permit you to do a sum(if(...)) in the interface.

Karl