Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I have two tables linked by a key field "Key_Date".
Table "Date" holds all dates. Table "InvoiceAnalysis" holds all dates for invoices. I have stored a table of both tables as Excel to check if records are plausible.
In the app a table selected only on table "InvoiceAnalysis" and just that field "%Key_Date" it shows for 2022 only the first calendar day of each month although the Excel file contains more entries. The subset ration of table "InvoiceAnalysis" shows 9% which seems to be low. Any ideas how to fix this issue?
Either your calendar is generated only for MonthStart Dates
or
You are only using the month Start Date in the key field instead of all dates in the months ie %Key_Date which is why only the 1st calendar date data is getting linked