Help with Multi row formula please

[DavidP07]

Hi, I would like to know why my multi-row formula is not working correctly, I would appreciate your help in correcting my statement please, thanks a lot.

[caltang]

Here is the proper syntax...

IF !IsNull([Industry])
THEN [Industry]
ELSE [Row-1: Industry]
ENDIF

[DavidP07]

Hi Caltang, thanks for your response, still the Industry records are not displaying correctly and I would like that the industry segment can fill the other blank spaces.

Thank you.

[caltang]

That's because your rows are not null, they're empty. Try this:

IF !IsEmpty([Industry])
THEN [Industry]
ELSE [Row-1: Industry]
ENDIF

[DavidP07]

Great that worked, but do you know how to remove those white spaces for Loan & Date Standard ... and Approved Loan.., I gotta group them for the next step but I was a little bit stuck with that exercise, take a look, thanks a lot for your support.

[caltang]

That depends. Let's assume:

Column A: Industry

Column B: Loan Date & Industry Standard Interest Rate

Column C: Approved Loan Interest Rate

Do you want to remove empty values from both Column B AND Column C? Or are you looking to remove empty values from either Column B OR Column C?

[caltang · Accepted solution]

If you want to remove empty values from Column B AND Column C

You can add a Filter tool and state:

!IsEmpty([Column B]) 
AND
!IsEmpty([Column C])

Else, if you want to remove values from either Column B OR Column C:

!IsEmpty([Column B])
OR
!IsEmpty([Column C])

I've attached an example workflow to show you the possible outcomes.

[DavidP07]

Hi Caltang, hope you are doing well, thanks for your response, I really appreciate it, I will take a look into it tonight but I think that with your help I got the problem solved.