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
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 
Best Answers

You can use SUM & LOOKUP to get the numbers but don't use them together. Split SUM & LOOKUP in different modules
0 
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!
0 
SUM and LOOKUPs are best to use. Don't be afraid to use them, be afraid to use them Together in one formula.
1