I have a rule and having a hard time writng a feeder. Can someone please help? The rule works but on zero suppress, it disappears.
Rule
Code: Select all
['Cost']=N: If ( ATTRS('Versions', !Versions, 'LiveVersion') @= 'Y' &
!Accounts @= DB('LaborGroupType', ATTRS('Projects', !Projects, 'PAG') , ATTRS('Employees', !Employees, 'LAB_GRP_TYPE') ,'Hours','R','Value') &
!Orgs @= ATTRS('Employees', !Employees, 'ORG_ID') ,
DB('Labor',!Projects,!Employees,!Months,!Versions,'Planned Cost')
+
DB('Labor',!Projects,!Employees,!Months,!Versions,'Planned Cost - Overtime'), stet );
Code: Select all
['Planned Cost'] =>DB( If( ATTRS('Versions', !Versions, 'LiveVersion') @= 'Y', 'SumProjLaborByAccts','') ,!Projects,!Employees,
DB('LaborGroupType', ATTRS('Projects', !Projects, 'PAG'), ATTRS('Employees', !Employees, 'LAB_GRP_TYPE') ,'Hours','R','Value')
, ATTRS('Employees', !Employees, 'ORG_ID') ,!Months,!Versions,'Cost');
['Planned Cost - Overtime'] =>DB( If( ATTRS('Versions', !Versions, 'LiveVersion') @= 'Y', 'SumProjLaborByAccts',''),!Projects,!Employees,
DB('LaborGroupType', ATTRS('Projects', !Projects, 'PAG'), ATTRS('Employees', !Employees, 'LAB_GRP_TYPE') ,'Hours','R','Value')
, ATTRS('Employees', !Employees, 'ORG_ID') ,!Months,!Versions,'Cost');
Paul.