2 Replies Latest reply: Mar 6, 2018 6:59 AM by Mina Patel RSS

    Problem with expression in a straight table some figures incorrect

    Mina Patel

      I have this calculation in my straight table, all rows are calculating the  correct figure except three rows highlighted

      Straight table.JPG

      My expression is this for avail credit line column, I have also attached the settings from chart properties.

       

      (Sum([Credit Limit])

      -

       

      ((Sum({<[OEL On Hold]={'Y'}, [OEL Credit Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>

            +

            <[OEL On Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>}

             If([Line Calc Tax Rate]>0,

            OE_Order_Lines_All.ORDERED_QUANTITY * OE_Order_Lines_All.UNIT_SELLING_PRICE*((100+[Line Calc Tax Rate])/100),

            OE_Order_Lines_All.ORDERED_QUANTITY * OE_Order_Lines_All.UNIT_SELLING_PRICE)

            )

      +

      Sum({<[OEL On Hold]={'Y'}, [OEL Credit Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>

            +

            <[OEL On Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>}

            [Freight Amount])

      )

      +

      (Sum([Acctd Amount Due Remaining])-Sum(Alt(AR_Receivable_Applications_All.AMOUNT_APPLIED,0)))))/1000