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.
Which version are you using because Sorry to repeat but I see different result than yours. The yellow highlighted error value must be 1 however it calculates as 2.
Additionally in original calculation you are using " DateAdd()" which is not a valid function in my alteryx therefor I change it to " DateTimeAdd()".
Ahhh good catch. I forgot that the 'DateAdd' function is not in the standard Alteryx package.
Try using this formula for the multi-row tool:
IF [Op Id]=[Row-1:Op Id] AND [Run Date] = DateTimeFormat(DateTimeAdd([Row-1:Run Date],1,'day'),'%Y-%m-%d') THEN [Row-1:error] ELSE [Row-1:error]+1 ENDIF
Yeah after I make the change on summary tool as below, this is exactly what I need. Thank you very much :)