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.
Does anyone know how I can apply a Row Rule in the Basic Table Tool to set the formatting for Null() values? I'm trying to automate an existing manual report format exactly with Alteryx. The field I'm working with is numeric (Int32) but contains some unknown values. I cannot set the null values to zero because they are not zero. They are unknown and need to be marked as null in the output per the required specifications. I know ISNULL() is not the right syntax but what will work?
Any row with a value >= 3 changes the row to red text. (This is working)
Any row with a null value changes the row to orange text (This is not working)
Sample workflow attached.
Applying Row Rules in the Basic Table Tool to Null Values.yxmd