0 Replies Latest reply: Apr 18, 2015 7:10 AM by Nayan Lalla RSS

    Struggling with Calculating Totals

    Nayan Lalla

      Chart Table.JPG

      Hi

       

      I am struggling to calculating a total in a straight chart table.  Above is an extract of my chart table showing stock on hand (sales value are hidden for simplicity)

       

      My formula above for Stock on Hand (SOH) is:

      SUM({$<[Sales Status]=>} [Loc Qty On Hand]))* [ComponentQty].

      However  the total for FEEMD is incorrect and should be 26,597 and not 26,205


      Reason the Sales Status field is excluded from selection is that for ZZBP1R/2R3 there is no sales but there is Stock on Hand (SOH)

       

      I then created a new column called SOH test with the following formula:

      sum(aggr(RangeMax((SUM({$<[Sales Status]=>} ([Loc Qty On Hand])))*$(vComponent_Qty)), [ITEM  CODE],[Component Code]))

      The total is fine, however the SOH for ZZBP1R/2R3 is zero instead of 78 .  

       

      The correct result should be as follows:

       

      Chart Table Correct Result.JPG

       

      Please can you help.

       

      Thank you

       

      kind regards

      Nayan