10 Replies Latest reply: Sep 20, 2013 6:14 AM by Nayan Lalla RSS

    Straight Table not affected by more than one selection

    Nayan Lalla

      Hi

       

      I have a formula below that works, where its not affected by [Cust Group] selection.

       

      I now want to add to this formula that will also not be affected by [Module] selection.

       

      How do i add this to the formaula.

       

      kind regards

      Nayan

       

       

       

      sum({<[Cust Group] => } if(MonthIndex >= ( vMaxMonthIndex -1)  and Branch='Johannesburg' ,

      [Order Quantity Backordered]*

      [Component Qty],0))