Data Sources Reading Rows with No Amounts
Is there a way to make a data source process rows that do not have a value in the Amount column?
For example, an import file has 4 rows:
| Account Name | Cost Center Name | Amount |
| Cash | G&A | 5,000 |
| AR | G&A | 5,000 |
| AP | G&A | |
| Retained Earnings | G&A | 10,000 |
OneStream will only process the Cash, AR, and Retained Earnings rows becuase the AP row has no value in the Amount column. While a complex expression can evaluate the empty amount in the AP row and retun "0", the Data Sources only processes the three rows into Stage.