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) .