Count of development Goals analysis

Summary

Can't add people with 0 Goals altogether with other Assignment fields

Content

Hi Team,

We are trying to build an OTBI analysis that lists Person Name, Person Number and (a few other assignment fields) and Count of Development Goals. There is only one more request: we also want the report to list those people who has 0 Goals created.

It works find by selecting the option Null Values in Data tab in Analysis Properties. The report lists the employees correctly - as per Screenshot1, when we select only facts from Worker folder.

However, as per screenshot2, when we add any assignment field outside the Worker folder, Grade Name, for example, the report crashes.