Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How do I return a member name where a value is at a MIN / MAX — 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

How do I return a member name where a value is at a MIN / MAX

Received Response
11
Views
7
Comments

Summary:

I need to find the MIN / MAX value of a given account across the cross dims shown below and I can do that using the @MINS / @MAXS functions. 

Next, I want to find and store in Account members, the member names of CustomDim_1, CustomDim_2 and CustomDim_3 where the value of Account_1 is at a MIN / MAX. 

This is where I need some help with the code - How do I get the members?


Content (required):

Here is the Fix to find the MIN / MAX value.

Fix(“Jan”,”FY21","USD","Actual","Working",”No Plan Element”,

              "Entity_1",  

              "No CustomDim_1",

              "No CustomDim_2",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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