Search Form with different conditions

[DaGi07]

Hello, I’m trying to do a search form using data from more than one tables in my app. I’would search the data on this condition–> If the project is “e-SicilyTravel BlockChain” and the partner is “Arancia-ICT”, go in table “Dati Personale” and SUM the column “Costo” where “Periodo” is >= than “DA”, <= than “A” and “Partner” is equal to "Arancia-ICT.
I tried whit this formula but It is wrong in the syntax

IF [Progetto]= “e-SicilyTravel BlockChain”,
AND [Partner]=“Arancia-ICT”,
SUM(
SELECT(Dati Personale[Costo],
AND ([Periodo]>=[DA],[Periodo]<=[A], [Partner]= “Arancia-ICT”)
))

The search form is this one

The main problem is that I have different project and different partner and it means that the formula could be very complicated.
I hope in your support.
Thanks

[Marc_Dillon]

DaGi07:

IF [Progetto]= “e-SicilyTravel BlockChain”,
AND [Partner]=“Arancia-ICT”,

Should be:

IF( AND( [progetto] = xx , [partner] = yy ) , ...

DaGi07:

The main problem is that I have different project and different partner and it means that the formula could be very complicated.

Have you looked at IFS() yet?

help.appsheet.com

IFS()

First-match conditional evaluation

[DaGi07]

I tried with your support but It ask the third input…

[Marc_Dillon · Accepted solution]

Yes, you need to supply an “else” value in an IF().

help.appsheet.com

IF()

Either/or conditional evaluation

[DaGi07]

thanks Mark, I wouldn’t open a new topic for a similar problem in which i’m fallen…
In this case, i would obtain a percent value because i have to divide the value [Totale] for the value [Budget Totale Partner] that it’s situated in the table “Totale Progetto”

IFS(
(
AND([Progetto]=“e-SicilyTravel BlockChain” , [partner]=“Arancia-ICT”),
SELECT(Totale Progetto[Budget Totale Partner],[partner]=“Arancia-ICT”)/[Totale]
))

[DaGi07]

No probem, I solved!!