Do you have an S- or P- account?

If so, you need SAP Universal ID. In a few months, SAP Universal ID will be the only option to login to SAP Community. Without it, you will lose your content and badges. If you have multiple accounts, use the Consolidation Tool to merge your content.

May 22, 2014 at 05:55 PM
# Sum of a formula

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