Multi row Formula issue

[Joker_Hazard]

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?

[jrgo · Accepted solution]

Hi @Joker_Hazard 

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

[shreyanshrathod · Accepted solution]

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