How to test if SELECT() returns nothing or not

[Neset_Kutlug]

Hi Everyone,

I am trying to test if the following SELECT expression returns NULL or not.

SELECT(
Transactions[Date],
AND( [Name] = [_THISROW].[Name] ,
[Type] = ‘Exit’
)
)

Thanks a lot…

[Marc_Dillon]

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

ISNOTBLANK()

Is value present?

[Neset_Kutlug]

Thanks Marc

[Koichi_Tsuji]

Test your expression over the Expression Assistant.

[Neset_Kutlug]

Thanks Tsuji.