Skip to Content
0
Former Member
May 22, 2014 at 05:55 PM

Sum of a formula

17 Views

Hi,

I have a formula, @Sum_NonComm_5_POS_BOM, in my Group 5 Footer

// Sum_NonComm_5_POS_BOM

whileprintingrecords;

global numbervar Sum_NonComm_3_Inv;

global numbervar Sum_NonComm_5_POS;

global numbervar Sum_NonComm_5_POS_BOM;

if {@Flag_POS_Non_Comm}

then Sum_NonComm_5_POS_BOM := Sum_NonComm_5_POS

else Sum_NonComm_5_POS_BOM := Sum_NonComm_5_POS + {Commission.POS_FI_NETTO_GES};

Sum_NonComm_3_Inv := Sum_NonComm_3_Inv + Sum_NonComm_5_POS_BOM;

Sum_NonComm_5_POS_BOM;

I also have another formula, @CommType_5_POS_BOM_Rate, in Group 5 Footer, which is calculated elsewhere, so very simple.

// CommType_5_POS_BOM_Rate

whileprintingrecords;

global numbervar CommRatePOS;

CommRatePOS;

In Group 3 Footer, I need to create a formula that sums @Sum_NonComm_5_POS_BOM only where @CommType_5_POS_BOM_Rate is not 0.

Syntax is eluding me.

Thank you,

Matt