TM1 RULE not consolidating
Posted: Tue Jun 21, 2022 7:03 am
Good day All,
I am having a challenge with the following rule
['Opening Balance'] = If((ATTRS('Calendar',!Calendar , 'IsMonthApril')@='Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags')@='Y') ,0,DB('MDA Trial Balance ',!Calendar,!Version,!Data Source,!Client,!Property Sector,!Property Grade,!Property,!Account - MDA,'Opening Balance'));
I am trying to make opening balance zero since it is the beginning of the financial year , the rule does return the zeros for the specified cells but doesn't consolidate to the top level.
when i specify N: it doesn't not work at all .
Any direction or help would be much appreciated
I am having a challenge with the following rule
['Opening Balance'] = If((ATTRS('Calendar',!Calendar , 'IsMonthApril')@='Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags')@='Y') ,0,DB('MDA Trial Balance ',!Calendar,!Version,!Data Source,!Client,!Property Sector,!Property Grade,!Property,!Account - MDA,'Opening Balance'));
I am trying to make opening balance zero since it is the beginning of the financial year , the rule does return the zeros for the specified cells but doesn't consolidate to the top level.
when i specify N: it doesn't not work at all .
Any direction or help would be much appreciated