4 Replies Latest reply: Apr 2, 2012 3:17 AM by Celambarasan Adhimulam

Expression error

ahnet ceylan Mar 29, 2012 4:45 AM

Hi,

İn chart, I want to show last 6 months value as minichart in chart

My expression below.

I dont know what is wrong?

Sum({<[Rapor Tarihi] ={">=date(today()-240),[Arıza Rapor Yılı]="} >} [Karşılanan Çağrı Oranı])

Expression error

anantneo Mar 29, 2012 7:36 AM (in response to ahnet ceylan)

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
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
Expression error

ahnet ceylan Apr 2, 2012 3:12 AM (in response to ahnet ceylan)

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
Like Show 0 Likes (0)

Actions
- Expression error
  
  Celambarasan Adhimulam Apr 2, 2012 3:17 AM (in response to ahnet ceylan)
  
  Hi,
  Try this
  sum( {<[Rapor Tarihi]={">=$(addMonths(Today(),-6))<=$(Today())"},[Arıza Rapor Yılı]=>} [Karşılanan Çağrı Oranı])
  
  Celambarasan
  
  Like Show 0 Likes (0)
  
  Actions