Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sir
My expression work fine :-
Sum(Aggr(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000), GROUP_CLASS))
I don't know how to modify the above expression to compute last 3 year sales. Hope some one can advise me.
Paul
my QVF
I don't have app access, Perhaps this?
Sum(Aggr(SUM({<year = {">=$(=AddYears(Max(year),-3))<=$(=Max(year))"}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {">=$(=AddYears(Max(year),-3))<=$(=Max(year))"}>}month), Num(Month(Today()))))"}>}sales/1000), GROUP_CLASS))
Hi Anil
Thank you very much. it work.
Paul
Hi Anil
I just try to change the -3 to any value for the below expression you given to me , i notice that it still display the same result :-
Sum(Aggr(SUM({<year = {">=$(=AddYears(Max(year),-3))<=$(=Max(year))"}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {">=$(=AddYears(Max(year),-3))<=$(=Max(year))"}>}month), Num(Month(Today()))))"}>}sales/1000), GROUP_CLASS))
When i visit the label it display >=10/7/1902<=2018 which not seen right.
Paul
Can you show that condition in text box and check?
Hi Anil
Do you mean like this ?
Is that values are correct?