## Sum basis Multiple Properties

Super 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

 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
3 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

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

Super Contributor

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!

Moderator

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

3 REPLIES 3
Moderator

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

Super Contributor

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!

Moderator

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