Hello and thanks. in the called sheet Nationa...

(Giuseppe Elio Nolfo) #1

Hello and thanks. in the called sheet NationalParks.gsheet I have a series of data([DATA ESCURSIONE][NOME][PREZZO] ECC). in another sheet under the heading [TOTALE GIORNO] I would like to get the sum of all single service bookings for the date I entered.

=SUM(

SELECT( NationalParks.gsheet[TOTALE],

AND(

[_THISROW].[DATA ]=NationalParks.gsheet[DATA ESCURSIONE ],

NationalParks.gsheet[ESCURSIONE]=“EGADI DAY”

)

) )

this is the error:Cannot compare Date with List in ([_RowNumber].[DATA] = NationalParks.gsheet[DATA ESCURSIONE])

can you help me?

[_THISROW].[DATA ] the tipe is data 12/06/2018 NationalParks.gsheet[DATA ESCURSIONE ] the tipe is data 12/06/2018

(Steven Coile) #2

Didn’t we already go over this?

Remove the references to NationalParks.gsheet in the AND() expression.

=SUM(

SELECT( NationalParks.gsheet[TOTALE],

AND(

[_THISROW].[DATA ]=[DATA ESCURSIONE ],

[ESCURSIONE]=“EGADI DAY”

)

) )

(Giuseppe Elio Nolfo) #3

YES I did not understand, it works perfectly, thank you very much