My current module has Year as the time dimension and my reference module has months as the time dimension. I want to return a field from the referenced module but only for the forecast period (Current Period is set to Jan19) & hence for FY19 that would be the sum of Jan19 to Jun19 and FY20 Jul19 to Jun20. My formula is below:
I have used the SELECT statement due to a dimensionality mismatch but when I enter the above formula I receive:
'An expression or constant may not be used as argument 1 of the function TIMESUM'
If I do the same formula to another module where this is no dimensionaliy mismatch it works fine, so it is the SELECT argument causing issues I believe
FYI - I am aware that I would need to do an IF ITEM(TIME) statement too to make sure that FY20 returns only FY20, not from Current Start Period to Jun20
1) Is there a way to use TIMESUM while using SELECT?
2) Is there a better way to return only forecast period values?