a month ago
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.
a month ago
Hi Gidon - There should be an option on the data source field in the Numeric Settings called 'Zero Suppression'. Set that to False and it should work.
a month ago
Right... This works with all source dimensions except for the Amount source dimension. The Amount source dimension determins whch rows a processed by the data source. Using complex expressions on other source dimenison works as long as the Amount source dimension has a value in it.
Setting the Zero Suppression to False does not make the Data Source process the record without an amount.
a month ago
Correct, I didn't realize you were trying to do it on the amount field. It is required to have a value.