AnsweredAssumed Answered

Chart from non duplicates

Question asked by vincer on May 17, 2018
Latest reply on May 17, 2018 by vincer

Hello !

Maybe this is easy but can't find how....

 

I have two tables:

 

Table_A basic fields:

- Table_sk

- Name

 

Table_B basic fields

- Table_sk

- Name

- Calc_Field (numeric, stored)

 

The two tables are related as

Table_A---<Table_B>---<Table_B_duplicate

 

In Table_B I have already flagged duplicates with a self-join and a specific field:

Record_Duplicate = If (Record_ID = Table_B_duplicate::Record_ID; ""; 1)

 

My question:

In Table_A, I need to show a chart of values from Table_B::Calc_Field only for non-duplicates records

 

Anyone may help please ?

Thank you,

Vince

Outcomes