Forum Discussion

Gidon_Albert's avatar
Gidon_Albert
Contributor II
4 months ago

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.

 

  • tschilling's avatar
    tschilling
    New Contributor III

    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.  

    • Gidon_Albert's avatar
      Gidon_Albert
      Contributor II

      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.

      • tschilling's avatar
        tschilling
        New Contributor III

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