This content has been marked as final.
Show 4 replies
-
Expression error
anantneo Mar 29, 2012 7:36 AM (in response to ali ceyli)Hi ,
try to use something like this
Sum({<[Rapor Tarihi] ={">=date(today()-240) <= date(today(),'DD/MM/YYYY' ) "} >} [Karşılanan Çağrı Oranı])
also you can take help from below code will help you for last six moths value
=Sum({<DateField={'>=$(=MonthStart(Max(DateField), -5))<=$(=MonthEnd(Max(DateField)))'}>} Sales)
Warm Regards,
Anant Debey
-
Expression error
Sunil Chauhan Mar 29, 2012 7:39 AM (in response to anantneo )use like below
sum( {<date={">=$(addMonths(date,-6))<=date={>=$(addMonths(date,0))"} sales)
hope this helps
-
-
Expression error
ali ceyli Apr 2, 2012 3:12 AM (in response to ali ceyli)Thanks for replies,
But they didnt work
[Arıza Rapor Yılı] the field expression wiil not be affected by it
Waiting for new solution
-
Expression error
Celambarasan Adhimulam Apr 2, 2012 3:17 AM (in response to ali ceyli)Hi,
Try this
sum( {<[Rapor Tarihi]={">=$(addMonths(Today(),-6))<=$(Today())"},[Arıza Rapor Yılı]=>} [Karşılanan Çağrı Oranı])
Celambarasan
-