elaubmeyer
Canvas Initiate

Sum values over a list column in a formula

Jump to solution

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

0 Kudos
Reply
2 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Sum values over a list column in a formula

Jump to solution
Hi.

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

View solution in original post

0 Kudos
Reply
elaubmeyer
Canvas Initiate

Re: Sum values over a list column in a formula

Jump to solution

Thanks for the reply,

 

works fine 🙂

0 Kudos
Reply