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
