Sum basis Multiple Properties

[ankit_cheeni]

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

Dimension	Property 1	Property 2	Property 3	Amount	Sum
a	x	y	z	1	3
b				1
c	x	y	z	1	3
d				1
e				1
f	x	y	z	1	3
g				1
h				1
i				1

[Misbah · Accepted solution]

@ankit_cheeni 

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

[ankit_cheeni · Accepted solution]

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!

[Misbah · Accepted solution]

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