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)
@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.
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |