Skip to Content
0
May 15, 2020 at 02:35 PM

Adding Up the Max Value of Multiple Details for one Overarching Object

109 Views Last edit May 15, 2020 at 03:28 PM 2 rev

Do you know how to add multiple Object Details (SubUniqueID_Description) based on the max Detail in an Object Dimension (Uniqueid)? I know I can convert my Detail to a number by using the Function, ToNumber, but my real problem is finding the max for each UniqueID and then adding each of those max’s up. I hope the below breakdown adds clarity:

Core Problem

Where I need help:

My current equation keeps returning 2,000,000 but I haven’t figured out how to return the 4,000,000. See below:

=(Max((ToNumber([SubUniqueID_Description])/1000))) In([Deal_ID])

Are there any objects that will "lock" in the max SubUniqueID_Description in a SubUniqueID, so I can then add each SubUniqueID's max value and arrive at the total Deal_ID level?

Is it even possible to find the max for each UniqueID and then add each those max’s up?

More clarity on my database:

The below table (named "Structure of Data") shows an example of the structure that I'm pulling my data from. Think of a SubUniqueID as the most granular record within a UniqueID. Its granular so I need to report the SubUniqueID_Description from a higher level, i.e. UniqueID or Deal_ID. To move higher up the chain, there are multiple UnqueID’s within a Deal_ID. I know it seems odd that I'm entering in a number in our database in a Detail field, but that has to be our process. I'd imagine if this was a metric it might be easier. Hope the below table helps.

Structure of Data

Thank you all in advanced for taking a look at this! I really appreciate your expertise. I know I haven't been very active posting and responding on these forums like you all, but its a long road to to get to your levels!

Thank you,

Steven

PS - Ayman, you were so very helpful a few months ago. I really can't thank you more. So I tagged you in case your expertise can be applied here! I hope that is ok. Thank you in advance if you are around to take a peek :)

Attachments

mcrdc.png (41.1 kB)
ggb1f.png (13.7 kB)