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