A doubt in functionality of "ALL" function

Hii Community,

Here, Source module contains Employees Dimension, Department and Country as List formatted Line Items and Bonus as Boolean format Line Item as shown below.

Target module contains Country as Dimension and Employees with Bonus as a Boolean formatted Line Item as shown below.

When I am using "ALL" Function here in Employees with Bonus Line item, it is giving TRUE against India and China even though I haven't used China (Country) in Source module (Country Line Item). Can someone answer this whether my understanding is incorrect or "ALL" Function is not working properly.

Please Let me know if you want further details, Thanks in advance.

With Regards,

Dileep

Accepted answers

Dileep777

Thank You! @AjayM, Now it is clear.

With Regards,

Dileep.

All comments

sobaid

Hi @Dileep777

You can drill down on the boolean in the second grid by clicking on right click against the boolean (you can even further drill down to go to the source) .

AjayM

Hi @Dileep777 ,

ALL function returns TRUE both for NONE Mapped cases and ALL Mapped cases - in other words, even though you have China in country list, no employee is mapped to China, and zero mapped against China returns TRUE, while any number less than ALL mapped returns FALSE.

I have given you a workaround to achieve what you want, which can further be simplified by avoiding few lineitems in target module.

Source Module:

Target Module:

Note 'All Function' lineitem: France returned FALSE as only one of the two mapped employee have BONUS. US West returned FALSE as none of the mapped employee get BONUS.

Hope this is clear.

Cheers!

Dileep777

Thank You! @AjayM, Now it is clear.

With Regards,

Dileep.

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.