Relation issue

[abc_777]

Hi,

I have following relation

where invoice and Store ID concatanate with SSummar and Sales Table with many to one in both direction

then i have bmcalendar with sales table many to one single direction 

when i take invocie_dt from ssummary table only march 2023 to filter net_AMT i got correct result

 but when i take march 2023 from bmcalendar table and filter i got incorrect result

interesting this this is happened some month like march 2023, november 2022 etc. other than those most months are ok. so how i really identify the issue

I drill down and found that 29-03-2023 has issue. in my data view i have 4 invoises but in visual when i use bmcalendar is not reading one imoive which is invoice number INVOICE_NO = 0023032900009 and has Net_amt is 985

0023032900009
0023032900024
0023032900004
0023032900023

so when i filter invoide_dt from ssummary table it has no issue but when filter using bmcalendar table it not getting one invoice. i checked this 0023032900009 is same as other 3 invoice rows and is in data view. but not showing in visual

what could be the possibility issue for this specific day in month of calendar.  please help

thanks

[lbendlin · Accepted solution]

what made you choose "both directions"?