SOLVED
Multi row Formula issue
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Joker_Hazard
11 - Bolide
‎08-27-2021
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
2 REPLIES 2
jrgo
14 - Magnetar
‎08-27-2021
01:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
11 - Bolide
‎08-29-2021
04:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)