Skip to main content

Hey all,


I will sum values from my list in the Nintex list formular by filtering over a dropdown-value.


For example:


I have a list like this:


customer_number; Projekt; amount;


In real:


1; 0814;100


2; 0816;100


1; 4711;120


1; 0999;110


3; 0816;300


 


In my formular I have a dropdown to select customer_number. In a formula field I will see the sum of all amount-field of the customer. So when I select customer_number 1, the formula field should write 330 to the formular at runtime. When customer_number 2, then 100 and so on.


 


Have sombody a hint?


 


Best regerads and thanks


Eric

Hi.

sum(lookup("ListWithDetails","customer_number",NamedChoiceControl,"amount",true))

Thanks for the reply,


 


works fine 🙂


Reply