ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community is currently in implementation of the new SSO experience starting at 5pm MDT. PLEASE DO NOT POST ANYTHING. For more information, read the blog.

Alteryx Designer Discussions

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

Question For Multi Row Formula

bmay10
7 - Meteor

I am asking for help with the "Multi-Row Formula."

 

From most examples, they show how to fill in rest of the cells that are missing. 

 

But, this situation is a little bit different. 

 

The highlighted section is where I am trying to fill in "North" by Region and "1,000" by Grand Total.  

 

I know a Transform tool can fix the problem, but I am trying to figure out how to use the "Multi Row Formula" tool.

 

Currently, it is showing false on the "Variable" row. Sometimes, it shows "True." I have been working on it for some time and I am trying really hard to get this working.

 

 

bmay10_0-1613158354416.png

 

 

 

 

bmay10_1-1613158945952.png

 

There is an attachment for the example. 

 

 

 

AngelosPachis
15 - Aurora

Hi @bmay10 ,

 

This is probably a question that should go in the Designer discussion page but I will try and answer it here.

 

There is no need for a multi-row formula tool I reckon, a simple formula tool would do it. Try to edit the [Variable] column and the formula should be

 

 

IF [Title]="Region" then "North"
ELSEIF [Title]="Grand Total" THEN "1,000"
ELSE [Variable]
ENDIF

 

 

But I think the issue here might also be that the field [Variable] is a Bool data type, so probably you should consider changing that to a string

 

AngelosPachis_0-1613330301820.png

 

 

Hope that helps,

 

Cheers

 

Angelos

 

 

 

bmay10
7 - Meteor

Thank you. Yeah, it was cause it was setup as a bool, not as a double. 

Labels