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
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โ
)
) )
YES I did not understand, it works perfectly, thank you very much
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |