<body>Hello Friends, I want the last transaction date of the customer who does not have done any transaction since one month or more than one month. Pls go through with the following expression: if(Sum({$<Year=,Quarter=,Month=,MonthNum=,Week=,Day=,Date=>} if(TRANSACTION_DATE >=addmonths(vMaxCreateDate,-vInActiveMonths) and TRANSACTION_DATE <= vMaxCreateDate,SalesDetail_Amt)) =0 ,1,0) Here VMAXCREATEDATE is my current selection date and vInactive month is having value '1' that will be deducted from current selection date and will give me date of current minus 1 month . password and userid is admin and admin Please suggest me how can i achieve this by using set analysis or by any other methode. Waiting for the reply.. Can mail me at: dushyant.ntpc@gmail.com Regards, Dushyant</body>
