5 Replies Latest reply: Jan 10, 2018 4:09 AM by Andrea Gigliotti

Use of less than in set analysis expression

Balaji SJ Jan 10, 2018 3:52 AM

Hi People

I have a requirement to build bar chart with sales of selected year and less than selected year.

I have used this expression to show previous year data,

=Sum({$<acc_period_year={"<acc_period_year"}>}bill_size)

But the expression gives null values. Please help me correct the expression.

Thanks

Balaji

Re: Use of less than in set analysis expression

aparna v Jan 10, 2018 3:55 AM (in response to Balaji SJ)

May be try this,
Sum({< acc_period_year = {"$(=max(acc_period_year)-1)"}>} bill_size)
Like Show 1 Like (1)

Actions
- Re: Use of less than in set analysis expression
  
  Balaji SJ Jan 10, 2018 4:01 AM (in response to aparna v)
  
  Thanks for the reply aparna.
  
  your expression gives me sales value of only the previous year. But i want to display sales value of all the years below the selected year.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Use of less than in set analysis expression
    
    aparna v Jan 10, 2018 4:06 AM (in response to Balaji SJ)
    
    For that you can just subtract the max year by -2 for getting previous year sales
    
    Like Show 0 Likes (0)
    
    Actions
  - Re: Use of less than in set analysis expression
    
    An Pham Jan 10, 2018 4:07 AM (in response to Balaji SJ)
    
    Try This
    Sum({< acc_period_year = {"<=$(=max(acc_period_year)-1)"}>} bill_size)
    regards
    An Pham
    
    Like Show 1 Like (1)
    
    Actions
Re: Use of less than in set analysis expression

Andrea Gigliotti Jan 10, 2018 4:09 AM (in response to Balaji SJ)

try this below:
Sum( {< acc_period_year = {"<$(=max(acc_period_year))"}>} bill_size)
Like Show 1 Like (1)

Actions