Open Points : 1. Reveune by state - What is "Keep (none) and (blank) apart Table forms only. Legacy: NULL and empty state are two rows" **What it means** Some revenue lines have no state on the transferee's file. In `DatawarehouseNCM.dbo.FactRevenueByState` the State column is empty in two different ways: | Shown as | Value in the database | January 2026 | All dates | |---|---|---|---| | (none) | NULL (no value at all) | 67 lines, $70,709.88 | 14,185 lines | | (blank) | '' (an empty text value) | 19 lines, $6,517.89 | 27,434 lines | The totals query (`02 Revenue By State Totals.sql`, `GROUP BY f.State`) returns these as **two separate rows**. So January 2026 gives 45 states. Merged into one "(No state)" row, it would give 44. "Keep apart" copies the legacy behaviour: two rows. "Merge" would show one row, $77,227.77 for January 2026. The total revenue is the same either way. "Table forms only" means it only changes the State Summary table. The Power BI chart has no bar for lines with no state in either case, as in the Power BI screenshot. The card total includes them. **What the Phase 1 report does now** The option is removed from Phase 1. State Summary keeps (none) and (blank) as two rows, so it matches the totals query and the legacy report. **Questions for the team** 1. Should State Summary show NULL and empty state as two rows (legacy, matches the query) or as one "No state" row? 2. What should the row be called: "(none)" / "(blank)", "(Blank)" as in Power BI, or something like "State not recorded"? 3. The Power BI chart has no bar for lines with no state ($0.48M in 2025), but its card total includes them. Should the chart show a "No state" bar so the bars add up to the card? 4. These lines have no state on the transferee's file, so for tax reporting they cannot be put against any state. Should the data team (Komal) be asked to fill in the state at source?