Expression in excel file

[Dave_Willett]

<<Start: FILTER(“WorkshopComplete”, ([JobID]=[_THISROW].[JobID]))>><<[Outstanding Parts]>>
<>

I have the above expression to pull [Outstanding Parts] from a dataset, it is a workflow and the expression is in a cell in an excel report.
When it runs it not only pulls the outstanding part but alot more data too:

08/10/2021 22/10/2021 14:54:59 FRT BUMPER WIND DEFL , 08/10/2021 22/10/2021 14:54:59 BONNET INSULATION , 08/10/2021 22/10/2021 14:55:00 L/W-HOUSE LINER BRKT , 08/10/2021 22/10/2021 14:58:08 L/F TYRE

I only want to pull:
FRT BUMPER WIND DEFL
BONNET INSULATION
L/W-HOUSE LINER BRKT
L/F TYRE

What am I doing wrong?

[1minManager]

My guess is the filter formula is pulling in all the data from 4 columns and creating an array of data. I suggest redoing the formula as a select function where it ‘selects’ the Key column.

If this makes no sense, show screenshot of your table columns and the report template

[Dave_Willett]

Hi Simon
Heres the column from the table - “WorkshopComplete”:

With a formula of:

Here is the template:

Does this help?

[1minManager]

Dave_Willett:

WorkshopComplete

Does the parent table have a virtual column called [Related WorkshopCompletes] ?

[Dave_Willett]

Hi Simon
The parent table is ‘WorkshopComplete’ and the virtual column [Outstanding Parts] uses this formula to pull data from a slice called ‘Recalls’:

In form view , UX, this works fine.

[Dave_Willett]

I really need this to work guys

[1minManager]

I’ll DM you

[1minManager]

Did you see my DM?

[Dave_Willett]

Problem solved and eternally greatful for the assistance. Thanks Simon, highly recommended.

Kind Regards