Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Not sure why you have the last expression on failure of if(mod(Month(DATE),3) = 0, -> Sum({<INDICATOR_NAME={'FRCOSTRT Index = France Housing Starts Total'}, MONTH={3,6,9,12}>}INDICATOR_VALUE)
But this seems to add up the last three months of data:
=If(Mod(Month(DATE),3) = 0,
If(Month(DATE) -1 = Month(Above(DATE)) and
(Month(DATE) -2) = Month(Above(Above(DATE))),
Above(Sum(INDICATOR_VALUE)) + Above(Above(Sum(INDICATOR_VALUE))) + Sum(INDICATOR_VALUE)))
With regards to October 2001 missing, I actually see the data. Is it after you make a selection in country the data is not present?
Let me know if I am moving in a completely wrong direction here.
Best,
Sunny
This?
Expression:
=If(Mod(Month(DATE),3) = 0,
If(Month(DATE) -1 = Month(Above(DATE)) and
(Month(DATE) -2) = Month(Above(Above(DATE))),
Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)) +
Above(Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE))) +
Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)))
Does this resolve the issue?
=If(Mod(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)),3) = 0,
If(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -1 = Month(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE))) and
(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -2) = Month(Above(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)))),
Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)) +
Above(Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE))) +
Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)))
Output:
Deepak I see two values on a single date, how are you planning to handle these? For example: 3/31/2015 and 6/30/2015 are repeating with different values.
Yet another attempt 
Expression:
=If(Mod(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)),3) = 0,
If(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -1 = Month(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE))) and
(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -2) = Month(Above(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)))),
Above(Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}Aggr(Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE), DATE))) +
Above(Above(Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}Aggr(Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE), DATE)))) +
Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}Aggr(Max({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE), DATE))))
Output:
