<<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?
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
2 Likes
Hi Simon
Heres the column from the table - “WorkshopComplete”:
With a formula of:
Here is the template:
Does this help?
1 Like
Dave_Willett:
WorkshopComplete
Does the parent table have a virtual column called [Related WorkshopCompletes] ?
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.
I really need this to work guys
1 Like
Problem solved and eternally greatful for the assistance. Thanks Simon, highly recommended.
Kind Regards
3 Likes
