Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
William2
Contributor III
Contributor III

Variables

Hello experts, 

since I am not able to add a write back table in my App where user can write directly into it I am looking for an alternative. 

I would like to filter a field for example with 50 of 10.000 values. This is no problem because I can enter this values straight into a filter panel. The challenge is that I want to add quatities to every filtered value.

e.g. 

filtered Materialnumber; user added quantites

1234; 50

1323; 12

4324; 30

5235; 20

2353; 10

and so on

these quantities will be used for different calculation so everywhere Materialnumber is 1234 calculate with 50 . 

I am not able to use a reload button to read an excel file dynamically, so user have to input the quantites in front end.

I would also avoid to create a variable for every filtered value. 

Maybe something like a variablelist where I store materialnumber and quantites and a set expression where I iterate through the varialbe liste for calculation ?

I would appreciate some hints or  links to already existing solutions. 

Thank you guys 

Best wishes 

Will  

0 Replies