Question For Multi Row Formula

[bmay10]

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.

There is an attachment for the example. 

[AngelosPachis · Accepted solution]

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

Hope that helps,

Cheers

Angelos

[bmay10]

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