You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Oct 2, 2019 8:39AM in Planning 16 comments


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


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;

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!