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...
Forum Discussion
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.
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.
Correct, I didn't realize you were trying to do it on the amount field. It is required to have a value.