FILTER("PUTAWAY DETAILS",
IFS([_THISROW].[SELECT TYPES]=Generate Daily Report,
AND([ENTRY DATE]>=[Repack Date],[STICKER COMPLETE DATE]<=[Sticker Date])
,
[_THISROW].[SELECT TYPES]=Download Sticker Person Report,
[STICKER PERSON]=[_THISROW].[Sticker Person Name],
[_THISROW].[SELECT TYPES]=Download Table Person Report,
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name],
[_THISROW].[SELECT TYPES]=By Date and Sicker Person,
AND([STICKER COMPLETE DATE]>=[Sticker Date],[STICKER COMPLETE DATE]<=[Sticker Date],[Sticker Date]=[_THISROW].[Sticker Person Name]),
[_THISROW].[SELECT TYPES]=By Date and Table Person,
AND([ENTRY DATE]>=[Repack Date],[ENTRY DATE]<=[Repack Date],[TABLE PERSON NAME]=[_THISROW].[Repack Person Name]),
[_THISROW].[SELECT TYPES]=Default Data,TRUE
)
)
Cannot compare List with Text in ([TABLE PERSON NAME] = [_THISROW].[Repack Person Name])
Tell me what's wrong with it.
Solved! Go to Solution.
Did you try this one?
@Aurelien wrote:
1) can you try using quote marks?
FILTER("PUTAWAY DETAILS", IFS([_THISROW].[SELECT TYPES]="Generate Daily Report", AND( [ENTRY DATE]>=[Repack Date], [STICKER COMPLETE DATE]<=[Sticker Date] ), [_THISROW].[SELECT TYPES]="Download Sticker Person Report", [STICKER PERSON]=[_THISROW].[Sticker Person Name], [_THISROW].[SELECT TYPES]="Download Table Person Report", [TABLE PERSON NAME]=[_THISROW].[Repack Person Name], [_THISROW].[SELECT TYPES]="By Date and Sicker Person", AND( [STICKER COMPLETE DATE]>=[Sticker Date], [STICKER COMPLETE DATE]<=[Sticker Date], [Sticker Date]=[_THISROW].[Sticker Person Name] ), [_THISROW].[SELECT TYPES]="By Date and Table Person", AND( [ENTRY DATE]>=[Repack Date], [ENTRY DATE]<=[Repack Date], [TABLE PERSON NAME]=[_THISROW].[Repack Person Name] ), [_THISROW].[SELECT TYPES]="Default Data", TRUE ) )
How to apply in() function inside it.
@Sirfyaad wrote:FILTER("PUTAWAY DETAILS", IFS([_THISROW].[SELECT TYPES]=Generate Daily Report, AND([ENTRY DATE]>=[Repack Date],[STICKER COMPLETE DATE]<=[Sticker Date]) , [_THISROW].[SELECT TYPES]=Download Sticker Person Report, [STICKER PERSON]=[_THISROW].[Sticker Person Name], [_THISROW].[SELECT TYPES]=Download Table Person Report, [TABLE PERSON NAME]=[_THISROW].[Repack Person Name], [_THISROW].[SELECT TYPES]=By Date and Sicker Person, AND([STICKER COMPLETE DATE]>=[Sticker Date],[STICKER COMPLETE DATE]<=[Sticker Date],[Sticker Date]=[_THISROW].[Sticker Person Name]), [_THISROW].[SELECT TYPES]=By Date and Table Person, AND([ENTRY DATE]>=[Repack Date],[ENTRY DATE]<=[Repack Date],[TABLE PERSON NAME]=[_THISROW].[Repack Person Name]), [_THISROW].[SELECT TYPES]=Default Data,TRUE )
How can I use inside this function? Please help @Aurelien
1) can you try using quote marks?
FILTER("PUTAWAY DETAILS",
IFS([_THISROW].[SELECT TYPES]="Generate Daily Report",
AND(
[ENTRY DATE]>=[Repack Date],
[STICKER COMPLETE DATE]<=[Sticker Date]
),
[_THISROW].[SELECT TYPES]="Download Sticker Person Report",
[STICKER PERSON]=[_THISROW].[Sticker Person Name],
[_THISROW].[SELECT TYPES]="Download Table Person Report",
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name],
[_THISROW].[SELECT TYPES]="By Date and Sicker Person",
AND(
[STICKER COMPLETE DATE]>=[Sticker Date],
[STICKER COMPLETE DATE]<=[Sticker Date],
[Sticker Date]=[_THISROW].[Sticker Person Name]
),
[_THISROW].[SELECT TYPES]="By Date and Table Person",
AND(
[ENTRY DATE]>=[Repack Date],
[ENTRY DATE]<=[Repack Date],
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name]
),
[_THISROW].[SELECT TYPES]="Default Data",
TRUE
)
)
2) [SELECT TYPES] is an Enumlist?
Then you may want to change the previous expression and try some things like:
FILTER("PUTAWAY DETAILS",
IFS(CONTAINS([_THISROW].[SELECT TYPES],"Generate Daily Report"),
AND(
[ENTRY DATE]>=[Repack Date],
[STICKER COMPLETE DATE]<=[Sticker Date]
),
CONTAINS([_THISROW].[SELECT TYPES],"Download Sticker Person Report"),
[STICKER PERSON]=[_THISROW].[Sticker Person Name],
CONTAINS([_THISROW].[SELECT TYPES],"Download Table Person Report"),
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name],
CONTAINS([_THISROW].[SELECT TYPES],"By Date and Sicker Person"),
AND(
[STICKER COMPLETE DATE]>=[Sticker Date],
[STICKER COMPLETE DATE]<=[Sticker Date],
[Sticker Date]=[_THISROW].[Sticker Person Name]
),
CONTAINS([_THISROW].[SELECT TYPES],"By Date and Table Person"),
AND(
[ENTRY DATE]>=[Repack Date],
[ENTRY DATE]<=[Repack Date],
[TABLE PERSON NAME]=[_THISROW].[Repack Person Name]
),
CONTAINS([_THISROW].[SELECT TYPES],"Default Data"),
TRUE
)
)
EDIT
3) [SELECT TYPES] is a List?
If so, expression with CONTAINS would turn into:
IN("yourText", [_THISROW].[SELECT TYPES])
For reference:
Thank you very much for giving your valuable time. I will definitely reply you again after testing it.
I help you, but you must make an effort.
Read the documentation. Read my posts in this thread. Make tries.
@Aurelien wrote:FILTER("PUTAWAY DETAILS", IFS(CONTAINS([_THISROW].[SELECT TYPES],"Generate Daily Report"), AND( [ENTRY DATE]>=[Repack Date], [STICKER COMPLETE DATE]<=[Sticker Date] ), CONTAINS([_THISROW].[SELECT TYPES],"Download Sticker Person Report"), [STICKER PERSON]=[_THISROW].[Sticker Person Name], CONTAINS([_THISROW].[SELECT TYPES],"Download Table Person Report"), [TABLE PERSON NAME]=[_THISROW].[Repack Person Name], CONTAINS([_THISROW].[SELECT TYPES],"By Date and Sicker Person"), AND( [STICKER COMPLETE DATE]>=[Sticker Date], [STICKER COMPLETE DATE]<=[Sticker Date], [Sticker Date]=[_THISROW].[Sticker Person Name] ), CONTAINS([_THISROW].[SELECT TYPES],"By Date and Table Person"), AND( [ENTRY DATE]>=[Repack Date], [ENTRY DATE]<=[Repack Date], [TABLE PERSON NAME]=[_THISROW].[Repack Person Name] ), CONTAINS([_THISROW].[SELECT TYPES],"Default Data"), TRUE ) )
Still showing the same error. which was showing earlier. @Aurelien
[select Types] is a Enum
Did you try this one?
@Aurelien wrote:
1) can you try using quote marks?
FILTER("PUTAWAY DETAILS", IFS([_THISROW].[SELECT TYPES]="Generate Daily Report", AND( [ENTRY DATE]>=[Repack Date], [STICKER COMPLETE DATE]<=[Sticker Date] ), [_THISROW].[SELECT TYPES]="Download Sticker Person Report", [STICKER PERSON]=[_THISROW].[Sticker Person Name], [_THISROW].[SELECT TYPES]="Download Table Person Report", [TABLE PERSON NAME]=[_THISROW].[Repack Person Name], [_THISROW].[SELECT TYPES]="By Date and Sicker Person", AND( [STICKER COMPLETE DATE]>=[Sticker Date], [STICKER COMPLETE DATE]<=[Sticker Date], [Sticker Date]=[_THISROW].[Sticker Person Name] ), [_THISROW].[SELECT TYPES]="By Date and Table Person", AND( [ENTRY DATE]>=[Repack Date], [ENTRY DATE]<=[Repack Date], [TABLE PERSON NAME]=[_THISROW].[Repack Person Name] ), [_THISROW].[SELECT TYPES]="Default Data", TRUE ) )
Thnx you for your support ๐
Cannot compare List with Text in ([TABLE PERSON NAME] = [_THISROW].[Repack Person Name])
This is the error. The Table Person Name or Repack Person Name is a List or EnumList. You should use IN() or CONTAINS()
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |