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
34
Views
16
Comments
edited Oct 2, 2019 8:39AM in Planning 16 comments

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;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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