community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

issue occurances within a column

Meteor

Hi Mmenth

 

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()".

 

Capture3.PNG

Thank you

Selcuk

 

Bolide

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

 

Best,

mmenth

Meteor

Yeah after I make the change on summary tool as below, this is exactly what I need. Thank you very much :)

 

 

Capture.PNG

 

Labels