Summing of list items to another list item in the same list

Options
Dileepkumar B
Dileepkumar B Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi 

 

There is a requirement that we need to sum list items total to a specific list item in the same list  based on some selections 

 

User selects Yes/no one line item(drop down) and Revenue method on another line item(drop down)

 

Lis items which are having Yes should be summed to the % revenue method list item 

 

attached screenshot for reference

 

Thanks

Dileepkumar

Tagged:

Comments

  • Dileepkumar B
    Dileepkumar B Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    @KirillKuznetsov 

     

    No, A B C D are not inputs they are driven by a formula in Revenue module. We need to bring values from Revenue Module to Another module say Revenue Sum Module(Products list dimention) result should looks like this 

     

    DileepkumarB_0-1642682942149.png

     

  • tharuns98
    tharuns98 Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Hi,

     

    I have few questions on the requiremnet

     

    1.You want the revenue of A,B,C,D to be summed up on E so the value for E should be 8 ?

    2.What if there is a value in E, should it be overwritten by the sum of A,B,C,D or should it cumulate?

    3.Is the requirement is to sum up to only one list member within the list or to mutiple list members according to the needs?

     

    Thanks,

    Tharun.

Categories