Boolean Filter Line Item

Hi team,

I have a Filter module to calculate filtering at a row level due to some complicated requirements. There are 3 dimensions being:

Location L3

SS: GL - EBITDA Report (L3 in Hierarchy)

SS Channel - Budget Channels (No Hierarchy)

On Level 1 of the GL dimension (List Item: Income) it is returning TRUE in the 'OPEX Filter' line item but the calculation in the Line Item is:

NOT Exp Cat.Sales AND NOT Exp Cat.COS etc & both these Line Items are TRUE (Please see attached screenshot for results & blueprint) & hence I would expect a FALSE result in the 'OPEX Filter' Line Item

The SUMMARY is set to Formula & hence this cannot be the issue

Thanks

ScreenShot1_111423.PNG

ScreenShot2_111423.PNG

Accepted answers

All comments

shreyak.garg

Based on the second screenshot, there is an extra condition in the OPEX Filter line item about 'Location Regional...'. It might be useful to drill down and see where the TRUE/FALSE is coming from?

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

ChrisAHeathcote

@MarkTurkenburg

How is the boolean summarising up the hierarchies?

If your screenshot is showing a summary level of the L3 hierarchy then I suspect you may have this set as any.

Try using formula instead.

Alternatively, using drill down function to work your way down through the logic of the calculation.

Right click while you have the target cell selected and choose drill down from the menu or press F8 and the drill down feature will open.

Continue to drill down until you hit the bottom of the logic flow.

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

andrewtye

Always worth F8 on an unexpected result as it will usually show the answer!

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

MarkTurkenburg_*56377

Hi @andrewtye & @shreyak.garg

That was my 1st point of call but none of the formula conditions are passed (see screenshot)

The SUMMARY is set to Formula as per my prior screenshot of the Blueprint

Thanks

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

MarkTurkenburg_*56377

I found it - I did not wrap the final OR condition in brackets

Thanks team

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

andrewtye

Ah... it's your last item. Missed off a pair of ( ) around the GL L2 & GL L1.

Easily done!

Drill_Down_111514.PNG

Revised_Formula_111515.PNG

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
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…