Hello I created an app to manage reservations...

(Giuseppe Elio Nolfo) #1

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.

(Steven Coile) #2

#ERROR!

(Giuseppe Elio Nolfo) #3

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])