Final Rule for the Depletion Cube

After you finish creating calculation statements and feeder statements for the Depletion rule, the rule should appear as follows:

['6','Required']=DB('FishRequired','Total Fish Cake Types',!FishType,!Date,'Qty
Required - Kgs');

['Available']=DB('Inventory',!FishType,!Date,!DaysOld,'Quantity
in Stock - Kgs');

['Used']=N:IF(['Available']>=['Required'],['Available']);

['Required']=N:DB('Depletion',!FishType,!Date,DNEXT('DaysOld',!DaysOld),'Still
Required');

FEEDERS;

['Available']=>['Used'];

['6','Still Required']=>['5','Required'];

['5','Still Required']=>['4','Required'];

['4','Still Required']=>['3','Required'];

['3','Still Required']=>['2','Required'];

['2','Still Required']=>['1','Required'];

['Remaining']=>DB('Inventory',!FishType,IF(DTYPE('DATE',DNEXT('Date,!Date))

@='N',DNEXT('Date',!Date),'Dec-31'),IF(DTYPE('DaysOld',DNEXT('DaysOld;,

!DaysOld))in Stock - Kgs;)'

@='N',DNEXT('DaysOld',!DaysOld),'1'),'Quantity