Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you help me please to find the error in this expression :
=Max({1} Aggr(sum({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},Elapse={"<=$(=(Elapse))"}>} Sales_$(V_Currency)), Elapse,
[Due Year],
[Due Month]))/1000
this expression returns the result below :
Due Year
Due Month
Elapse
Backlog
58,558
2011
04
-36
29,721
2012
-50
11,706
-43
22,119
33,758
-29
46,705
-22
47,495
-15
49,322
-8
49,926
2013
9,983
21,439
33,712
45,932
54,289
57,664
What i want to see is sales for the Max Elapse ?
Thanks for your help