Reference One Column selection to another column, from list box

dondapati — Fri, 15 Nov 2024 23:49:52 GMT

Hello all,

In Text box , if user selected value from the list box, it reference to another column , corresponding matching rows.

Here my data looks like

Expect Combined_Type, Prod everything is available in list box.

if user select the Value Type = "E" and Plan = "Ken" then Combined_Type list contains value's sum prod(257, 957, 352) value come.

because, here Combined_Type column contains the "E"

I tried the trigger on Type column

WildMatch(Combined_Type, '*'& getfieldselections([Type],'*|*'))

But it not working,

Update:

I Tried Following

sum( DISTINCT {<[Type] = { "$(=GetFieldSelections([Type]))"}>} Production )

how to check

sum( DISTINCT {<[Combined_Type] = { "$(=GetFieldSelections([Type]))"}>} Production ) (Matching which are in Combined_Type)

Help me, how to reference one column to another column

Re: Reference One Column selection to another column, from list box

Chanty4u — Sun, 11 Oct 2020 12:02:29 GMT

can you try this?

=Sum({<Type = p(Type)>} Prod)

dondapati — Sun, 11 Oct 2020 13:05:18 GMT

Hi Chanty4u, Thank you for given reply.

Maybe i am not explain clearly, sorry for that.

In the same thing , if i include the list box for Type column and select value is E , then also the value is 1566 ,

because the selected value "E" is in 3 rows , with Combined_Type Column.
In the front end i can't place the Combined_Type Colum as List box.