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

Smartlist issue

Summary


Content (please ensure you mask any confidential information):

Hi,

We had an issue with smartlist, not sure about the root cause.

In business rule, we have a calculation like below:

"Account-2" = @MEMBER(@CONCATENATE("HSP_ID_",@HspNumtoString("Account-1"->"SL_DT"->"BegBalance"->"No Scenario"->"Working"))) → "Input"

"Account-1" is a dummy account just for input/select a smartlist,"SL_DT" has a smartlist based on dimension members from Account, for example @IDESC("Expense") which means a parent member cal also be selected. The problem is, if the smartlist selection is a Dynamic Calc parent for example,"Total Travel Expense" and "Total Travel Expense" has value for $100, the above calculation does not result anything("Account-2" is #MISSING) .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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