This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am having an issue with a total formula - I am trying to create a total column to sum 5 x columns of data - for 3 of the 20 rows I am getting 0 as the total unexpectedly.
I searched the forum and used the select function to ensure each of the subsidiary columns were "Double" - I also used data cleansing to ensure that blanks / 0 were replaced but still I am getting the nil values for these rows.
Would anyone have any ideas of how I might resolve ?
The reason why the select and data cleansing tools need to be added first is because Alteryx will automatically give a null value if it adds a number with a null value. The null value has to be set to 0 first if you want to add correctly.
With regards to the "ICR $000" field, perhaps it contains some strange data like null values?