data model question example

[zied_ahmed1]

Hello All,

I have two file excels like this , I need to count the number of project managed by younger Manager (there is 5 in our example )

Thanks for your help 

[tresB]

Several options are there, I would do it like:

And then UI expression: Count({<Flag={'Younger'}>} [Project Name])

[zied_ahmed1]

Thank you for your help but it didn't work for me ,

I think there is  no association in the two table 

[tresB]

You would not require the younger manager table/field once you create the Flag field in the main table. You can just drop that table.

[zied_ahmed1]

Please try the kpi  with Count({<Flag={'Younger'}>} [Project Name])

and you will see that doesn't work 🙂 

Thanks 

[tresB]

It works with me. Try to share your sample app where it doesn't work.