This content has been marked as final.
Show 5 replies
-
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)
-
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.
-
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
-
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
-
-
-
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)