IF user Selects any checkbox within 3 booleans then I want to include that in a scope

Hello,

I am wondering if I can use the IF formula to say that if a user selects any of the checkboxes within three separate columns (booleans) then I want to consider that within a scope.

	OPTION 1	OPTION 2	OPTION 3
A	X
B		X
C			X
D
E	X
F

Let's pretend this is the dashboard and that the "x" represent a check in a boolean list

Then I want to say that from those items only A, B, C and E are my scope

Do you have any solutions?

Accepted answers

Akhtar.shahbaz

Hi @CCOLMANT

You can try the below approach:

All comments

Akhtar.shahbaz

Hi @CCOLMANT

You can try the below approach:

rob_marshall

@CCOLMANT

Good question, I would not do a giant IF statement, but rather another boolean line item. So, Options is a list with a top member (All Options), and A through F is a list (Projects). Line items would be Valid (this is your boolean or what you currently have as an X), set the summary to Any.

In your SYS Projects module (the A through F), create a boolean line item named Valid Options? with the formula: Module.Valid where "module" is your matrix above. This will return any Project where Options are checked. This will effectively get you out of the nested IF statement.

Does that help?

Rob

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…