ANY(SELECT) IN AN IFS FUNCTION

[dpotoole1971]

Is it possible to use an ANY(SELECT) as one of the arguments in an IFS function?  I am creating an app to record Incident Reports.  If the incident occurs at one of 3 locations I want the address of the location to be a pre-determined value, if the incident occurs on a Project Site I want the app to pull the address of the project site from the Project Master Table.  This is the formula I have tried but I am getting a paranthesis error.

IFS(
(OR(
([PROJECT SITE OR OFFICE / SHOP]="ATELIER D’ENTRETIEN | MAINTENANCE SHOP"),
([PROJECT SITE OR OFFICE / SHOP]="COUR DE TRIAGE | YARD"),
([PROJECT SITE OR OFFICE / SHOP]="BUREAU | OFFICE"),
(120 - 27 BOULEVARD INDUSTRIEL"))),
(([PROJECT SITE OR OFFICE / SHOP]="SITE DU PROJET /// PROJECT SITE"),
(ANY(Select(PROJECT MASTER[ADDRESS]),[_THISROW].[PROJECT NAME]=[PROJECT NAME])))),
FALSE)

[Marc_Dillon]

---

@dpotoole1971 wrote:

Is it possible to use an ANY(SELECT) as one of the arguments in an IFS function?

---

Yep.

---

@dpotoole1971 wrote:

but I am getting a paranthesis error.

---

You have tons of unnecessary parentheses, so that certainly is making it harder to read. Also I recommend indenting subsequent lines within the same function, for even greater readability.