How to sum members based on Smartlist selection — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to sum members based on Smartlist selection

edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

How to sum members based on Smartlist selection

Content

Hi,

My requirement is I need to sum the entity members based on Smartlist selection.

Example: My smartlist A has two members A11 and A12 and my Entity has 5 members. For all 3 Entities that has Smartlist A11, I need to sum of all 3 Entities for smartlist A11 under one placeholder members in Account dimension say X1. What will my syntax

If (Smartlist==A11)

X1= ?

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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