Handle Null Values for Missing TAS, Obligation Difference, & Unlinked Columns

Description

As a user, I want to know the difference when an agency has not submitted anything and when an agency made an empty submission.

A/C:

On the Statistics by Submission Period tab and the single agency submission statistics page:

  1. When agency has no submission (the cell value is null)

    1. show –- for Obligation Differences column

    2. show -- for TASs Missing column

    3. show –- for Unlinked Financial Assistance column

    4. show –- for Unlinked Contract Assistance column

  2. When an agency has a submission and the cell value is zero

    1. show $0.00 for Obligation Differences column

    2. show 0 for the other columns

  3. For all of the above columns, when a cell’s value is --, do not show the modal button on hover

    1. Maintain the existing logic for showing the modal button for zero values (Obligation Differences column should still display the modal button for $0.00)

 

Tech Approach

  • When an agency has no submission, the values for these columns will be returned as null from the API per

  • The CoreReportingRow data model formats these properties for both pages

Activity

Show:
Melissa Plooksawasdi
April 30, 2021, 2:54 PM

https://staging.usaspending.gov/submission-statistics/agency/524 - Agency with no submissions in Period 5 showing --

When agency has no submission, -- is shown for Obligation Differences column, TASs Missing column, Unlinked Financial Assistance column, and Unlinked Contract Assistance column.

When an agency has a submission and the cell value is zero, $0.00 is displayed for Obligation Differences column and 0 for the other columns.

 

For all of the above columns, when a cell’s value is --, do not show the modal button on hover

Jonathan Hill
April 28, 2021, 8:28 PM

Lizzie Salita
April 28, 2021, 6:04 PM

FYI we just noticed an issue with the FE logic (isNAN evaluates to true for null values), so we will need to move this back to “In Progress”

Jonathan Hill
April 23, 2021, 7:52 PM

Done

Sprint

Assignee

Unassigned

Reporter

Max Kendall

Components

Labels

Priority

Medium

Story Points

3