Tableau Output Error invalid value Decimal it must be a float instance.

[BAvitia23]

I have formula for field 2024 Ecomm Planned Burdens

tonumber (If LEFT([Posting Date],4)='2024' and [department]='Stock' then
(IF isNull([NS Ecomm Labor $]) then 0 else [NS Ecomm Labor $] endif
+
if isNull([NS Ecomm Non Labor $]) then 0 else [NS Ecomm Non Labor $] endif
+
IF isNull([NS Ecom Scrap Spillage]) then 0 else [NS Ecom Scrap Spillage] endif
) *0.94 else 0 endif)

The Data type is FixedDecimal Precision 19 Scale 6

when I try to publish the data to Tableau I'm getting this error:

Tableau Output (1081) Got an invalid value Decimal('0.000000') for column "2024 Ecomm Planned Burdens", it must be a float instance.

I added a Data Cleansing tool to replace nulls with 0 and remove leading and training white spaces, letters, punctuation, and still get the error.

Any suggestions appreciated

[aatalai]

@BAvitia23 is this as .hyper file? Just for intrest can you write it as an excel/csv file? As that might be  work around, to wirte it in excel and then use that as your data source