Urgent! Bi-Direction

[n1ef5ng1]

Hi Gurus,

See attached file below in QV,

I have this fields call Country_ID, Country_From and Country_To,

'List' table just show the value of Country_From and Country_To

If CN to ID is 30 box and ID to CN is 140 box, it will display 170 on the second table. This refers to table name call Bi Direction Between Country_From and Country_To.

Desired Table - Bi Direction

Now my problem is, when user select Country call Indonesia, it will have this //Code Here column where it will display the countries with bi direction value.

Basically is like Indonesia to any other countries with bi direction.

(Unable to do this on edit script)

I not sure if aggr will solve, if do please help.

Thanks! being stuch this problem for months

[n1ef5ng1]

Desired table expected value

BB - 50

BK - 15

CN - 170

DE - 80

DW - 34

FE - 48

ID-ID - 0

TK - 60

[luciancotea]

Code here: =replace(COUNTRY_FROM & COUNTRY_TO, COUNTRY_ID, '')

[n1ef5ng1]

ur example is correct, but it doesn apply to my report.

I realized there is no way to have ID to ID right?

[luciancotea]

Right. Without touching the script, can't do much.