$0 inputs are showing up as amounts greater than $0

Question

Hello,

I have a workflow that takes an input with 4 financial fields (labeled with 'Option' in the column headers of example). The workflow adds all of the fields (labeled as 'Total' in the column header of example) and then filters any amounts out that are not $0 using the filter tool. For some reason, the amounts that should be $0 are showing up as values other than $0. Attached is an example workflow and dataset.

Example: If I take the total of all of the "Option" fields for #1 I would believe the "Total" for it would be $0 but Alteryx is recognizing a number other than $0.

Any help with this matter is greatly appreciated.

Thanks!

Input File

After Alteryx Calculation - Shows an amount other than $0

Issue with Calculation.yxzp

Input.xlsx

datauser4234 · Answer

Thank you for taking a look at this. Do you by chance know what the technical reason in Excel could be that could be causing this issue?

Kinga · Answer

Hi @datauser4234

I made small thing: open Excel file and sum those figures there. It is look like that rather excel issue...

davidskaife · Answer

Hi @datauser4234

The trouble seems to be with the source data, as it's producing a value not equal to 0 in excel as well. However, if you change the data type for your Total calculation from double to Fixed Decimal that seems to work, with only records #2 and #3 comining through the filter.