Sum basis Multiple Properties

Highlighted
Frequent Contributor

Sum basis Multiple Properties

Hi, 

I have a module with 3 different list formatted LIs and an amount line item. I want to sum the amount in the module basis these line items such that any list item that has these 3 properties similar should show the same value. I know this could be done using sum and lookup but wanted to see if there is a better way to do this. Here is a mockup

DimensionProperty 1Property 2Property 3AmountSum
axyz13
b   1 
cxyz13
d   1 
e   1 
fxyz13
g   1 
h   1 
i   1 
3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Sum basis Multiple Properties

@ankit_cheeni 

 

You can use SUM & LOOKUP to get the numbers but don't use them together. Split SUM & LOOKUP in different modules

Highlighted
Frequent Contributor

Re: Sum basis Multiple Properties

Hi @Misbah Boss!

I am aware of the SUM and LOOKUP but we all know that isn't the best route to take. I was wondering if there is another way to do the same thing. If not, I guess you already validated the SUM and LOOKUP method. 

 

Thanks and Stay safe!

Highlighted
Master Anaplanner/Community Boss

Re: Sum basis Multiple Properties

@ankit_cheeni 

 

SUM and LOOKUPs are best to use. Don't be afraid to use them, be afraid to use them Together in one formula.