Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
sum( {< Status = {"=lower(Status) = 'present'"}, Date = {"=Date(Date,'YYYY/MM/DD') = '2023/08/09'"} >} state)
Change the field name [Date] for the Date() function to the field name [Sheet1-1.Date]
Try:
sum( {< Status = {"=lower(Status) = 'present'"}, Date = {"=Date(Date,'YYYY/MM/DD') = '2023/08/09'"} >} state)
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
Change the field name [Date] for the Date() function to the field name [Sheet1-1.Date]