welcome everybody
I'm having a problem automating the export of a PDF file
I think the script in the starting box has a problem
ISNOTBLANK() produces a Yes/No result, not a list of Keys.
Try removing that one.
Also, why you though you needed it in the first place? Just to get the idea
Seems like you removed the <<End>> after <<[Operation]>>
The <<End>>
has to be after <<[Operation]>>
, not before, and it's not a column so don't use []
Seems like it
You should try it once.
ISNOTBLANK(FILTER("FILTERBRANCH", AND(
[_THISROW].[DATE] >= [Start Date],
[_THISROW].[DATE] <= [End Date],
IN([_THISROW].[BRANCH], SPLIT(FILTERBRANCH[Branch], ",")),
IN([_THISROW].[OPERATION], SPLIT(FILTERBRANCH[Operation], ","))
)))
All columns in the template will be added to the Slice column.
<<Start: FILTER("FILTERBRANCH",
AND(
([_THISROW].[DATE] >= [Start Date]),
([_THISROW].[DATE] <= [End Date]),
IN([_THISROW].[BRANCH], SPLIT([FILTERBRANCH].[Branch], ",")),
IN([_THISROW].[OPERATION], SPLIT([FILTERBRANCH].[Operation], ","))
)
)>>
<<[ID]>>
<<[BRANCH]>>
<<[End]>>
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |