Hello guys
Anyone know how to fix this?
I know that there is no row afterwards to validate this formula, but I would like Alteryx to understand that if there is no subsequential row, then make "OK" instead of "Erro" at the last row.
Any ideas?
Solved! Go to Solution.
Try this. Doesn't matter which field the first condition uses, but suggest using STRING field and that the field always has a value.
IF ISEMPTY([Row+1:DESCRICAO_HISTORICO])
THEN 'OK'
ELSEIF [Sum_VALOR] = [Row+1:Sum_VALOR]
THEN 'OK'
ELSE 'Erro'
ENDIF
Hi @Joker_Hazard ,
please play around with "Values for rows that don't exist" in the MULTI-ROW formula Configuration window.
I have kept it as "Set to values of closest valid row" meaning your IF condition will always return TRUE for last record and hence "OK" will be output.
Hope this solves it.
Regards,
Shreyansh