Data Sources Reading Rows with No Amounts

Gidon_Albert
Contributor II

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.

 

3 REPLIES 3

tschilling
New Contributor III

2024-09-05 13_30_25-OneStream XF.pngHi 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.  

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.

Amount Source Dimension.png

Setting the Zero Suppression to False does not make the Data Source process the record without an amount.

Correct, I didn't realize you were trying to do it on the amount field.  It is required to have a value.