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

How to call an existing member within the @SLN function for the "lifeMbrConst" parameter

Hello everyone,

I am trying to leverage the @SLN function within a member formula, and want to use an existing account member as the selection for the lifeMbrConst parameter. My equation is here:

IF(@ISMBR("Custom - EDP equipment"))

@SLN("Input",0,"Asset Life",@LIST(@XRANGE(&FcstYr1->"Jan",&FcstYr1->"Dec"),@XRANGE(&FcstYr2->"Jan",&FcstYr2->"Dec"),@XRANGE(&FcstYr3->"Jan",&FcstYr3->"Dec"),@XRANGE(&FcstYr4->"Jan",&FcstYr4->"Dec")));

But doing that won't generate any data. However when I hardcode the lifeMbrConst parameter:

IF(@ISMBR("Custom - EDP equipment"))
@SLN("Input",0,24,@LIST(@XRANGE(&FcstYr1->"Jan",&FcstYr1->"Dec"),@XRANGE(&FcstYr2->"Jan",&FcstYr2->"Dec"),@XRANGE(&FcstYr3->"Jan",&FcstYr3->"Dec"),@XRANGE(&FcstYr4->"Jan",&FcstYr4->"Dec")));

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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