Hello I created an app to manage reservations, for more types of activities, now I would like to get control of the daily income for each activity, but I can not make the formula work.
=SUM(
SELECT( NationalParks.gsheet[TOTALE],
AND(
[DATA]=NationalParks.gsheet[DATA ESCURSIONE],
[DATA]=MONTH(NationalParks.gsheet[DATA ESCURSIONE],
NationalParks.gsheet [ESCURSIONE]=โEGADI DAYโ
)
) )
can you help me?the formula works but has always been 0 and can not compare dates.
#ERROR!
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])
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |