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



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,