Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in Planning 7 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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