Combining Boolean value for some condition.

Options
Malya727
Malya727 Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor
in Planning & Modeling

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 )

Tagged:

Comments

  • naushad786
    naushad786 Member, ALL USERS, Certified Model Builder Posts: 5 Frequent Contributor

     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.

     

    naushad786_0-1619687329412.png

    naushad786_0-1619688102437.png

     

    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.

     

    naushad786_1-1619687359980.png

     

    naushad786_2-1619687585991.png

     

    Hope it will help you.

     

    Thanks,

    Naushad

     

Categories