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

    Straight Table not affected by more than one selection



      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





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

      [Order Quantity Backordered]*

      [Component Qty],0))