Solved: Cannot Compare List with Text - Page 2

Sirfyaad · 04-05-2023 08:29 AM

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.

Aurelien

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
)
)

View solution in original post