Skip to main content
Member
Nov 1, 2024 9:20 PM UTC

Data sources zero suppression with complex expression

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6). 

ScottCharles_0-1730495141160.png

I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead.

ScottCharles_1-1730495277208.png

In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6.

ScottCharles_2-1730495605762.png

Is there a way to suppress zero after the script runs or write zero suppress into the script? 

Thanks Scott

2 replies

Expert
Nov 4, 2024 8:47 AM UTC
Member
Nov 4, 2024 8:04 PM UTC

Thanks Marcus H