By pressing 'TYPE' or 'Wire ' the value will not change as selected

[Sxbbb]

I have a field 'TYPE' , 'Wire ' , 'Output ' ,'Number'

in field  'TYPE' contains data  'TYPE1' and 'TYPE2'

in field  'Wire' contains data  'Wire1' and 'Wire2'

I want to display the value 'Output *'Number' where 'TYPE' = 'TYPE1'and 'Wire' = 'Wire1' always

By pressing 'TYPE' or 'Wire '  the value will not change as selected.

I tried the code but the value is not showing it's not right :

if(TYPE=''TYPE'1' and Wire='Wire1' , Sum(Aggr((Output*Number),Part,DATE,WorkOrderNo)))

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum({<Type={'TYPE1'}, Wire={'Wire1'}>}Output*Number)

[Sxbbb]

@MayilVahanan   I want to put Aggr. Where can I put the code?

I tried this and can't do it. Sum({<Type={'TYPE1'}, Wire={'Wire1'}>}Aggr(Output*Number,Part,DATE,WorkOrderNo))

[Sxbbb]

@BrunPierre It's the code I tried and the values ​​are not correct.

[Sxbbb]

I did it, thank you very much everyone.

[Sxbbb]

@MayilVahanan 

I tried using field 'TYPE' in a Listbox and found that the value changed depending on the type selected in the Listbox.

[MayilVahanan]

Is both  Output & Number are from same table?

[Sxbbb]

different tables

[MayilVahanan]

okay, then try like below

Sum({<Type={'TYPE1'}, Wire={'Wire1'}>}Output)*Sum({<Type={'TYPE1'}, Wire={'Wire1'}>}Number)

[Sxbbb]

it's not right Now the latest code I used is

Sum({<Type={'TYPE1'}, Wire={'Wire1'}>} Aggr((Output*Number),Part,DATE,WorkOrderNo)))