Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have scenario.
i need to generate sequence in my expression using a variable
Variable is input box which end user able to give value from front end.
Example: Input =1
then it is
1
2
3
4
5
6
..
.
numner of records.
I am able to get that using this below code
Rangesum(above(sum($(Sales Annual Growth Rate)),0,240))
1
2
3
etc
But i am looking for
it has to start from future dates that is greater then 2016
if(FiscalYear<=('Nov'&'/'&2016),0,Rangesum(above(sum($(Sales Annual Growth Rate)),0,240)))
This is giving
2011 0
2012 0
2013 0
2014 0
2015 0
2016 0
2017 7
2018 8
so here i want start 1 from 2017 ,so i am thinking instaed of 0 we need to give number of records before 2016,how to find this?
Please find the attached file and do the needful
Regards
Thiru
May be try using this expression:
=Rangesum(Above(Sum($(Sales Annual Growth Rate)), (Year(Today()) + 1 - $(StartDate)), 240))
Another option closer to your original approach might be
=Rangesum(above(if(FiscalYear<='Nov/2016',0,"Sales Annual Growth Rate"),0,240))