Sum basis Multiple Properties


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

DimensionProperty 1Property 2Property 3AmountSum
b   1 
d   1 
e   1 
g   1 
h   1 
i   1 

Best Answers

  • Misbah
    Answer ✓



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

  • ankit_cheeni
    Answer ✓

    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
    Answer ✓



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