Member formula is not working only for Jan-18 when calculating Average

@ismbr(&quot

Content

Hi All,

I have come across an issue where member formula is not working only for Jan-18. However for the other all the months it is working fine.

Logic of the Member formula is as follows.

This account (Let's say accnt Y) is to take average between any two given months (Prior month and current month) of Accnt X

Script1

IF(@ismbr("Jan") AND @ismbr("FY18"))

"S&P 500 Total Return %"=("S&P 500 Total Return" -> "Jan"/("S&P 500 Total Return" -> "2017" -> "Dec"))-1;

 

else "S&P 500 Total Return %"= ("S&P 500 Total Return"/ @PRIOR("S&P 500 Total Return"))-1;