Combining Boolean value for some condition.

I Have Boolean line item for a module which consists of country and employee List as dimension. for another module having country as dimension and one boolean line item how can i check boolean line item as true if any one of the employee data for that particular country is true in source module(consists of employee and Country List as a dimension )

Accepted answers

All comments

naushad786

Hi @Malya727 ,

I tried to replicated your issue.

I have created module having country and employee List and Boolean Line item and Line item Country List formatted.

I have created another module having country list Only with boolean line item where I have written formula. it will be true if any one of the employee data is there.

Hope it will help you.

Thanks,

Naushad

fabien.junod

Hello @Malya727

You can use the formula x[ANY:y]

https://help.anaplan.com/f96a79a4-4dd3-47bd-af4b-921409885a6c-x[ANY:y]

In your source module (dimensioned by Country and employee) you add a line item (I called it "Item Country") formatted with the country list and containing the country item. For that, you can create (if you don't have it already) a system module SYS Country that has a List item line item

ITEM(Country)

and reference it.

Module by country and employee.jpg

Then, in your target module (dimensioned by Country) you can use the x[ANY:y] formula

'Module by Country and Employee'.Boolean[ANY: 'Module by Country and Employee'.Item Country]

Module by country.jpg

Hope this helps

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…