EXPRESSION

[Prithika]

HELLO

I have the following dataset . i have to write an expression to show the state value if the status is 'present' and date is 9-aug-2023. can someone help me.

[Jan-Hendrik · Accepted solution]

Try:

sum( {< Status = {"=lower(Status) = 'present'"}, Date = {"=Date(Date,'YYYY/MM/DD') = '2023/08/09'"} >} state)

[Prithika]

did i made some mistakes its not showing any changes

field name of Status is status

field name of Date is Sheet1-1.Date

field name of state is state

[Jan-Hendrik · Accepted solution]

Change the field name [Date] for the Date() function to the field name [Sheet1-1.Date]