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