Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
in my model i transaction table
with fields : id, item, quantity ... etc.
loaded this table again with the fields : id, item_1
so the connection between the main table and the secondary is id.
in UI i want to use an expression to count (id) and sum (quantity) of all other items from the user selection in item_1
any ideas ?
advanced thanks
=count( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} id)
=sum( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} quantity)
=count( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} id)
=sum( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} quantity)