9 Replies Latest reply: Nov 10, 2014 11:33 PM by anbu cheliyan RSS

    Set Analysis with Multiple Modifiers

    Alec Smith



      I'm trying to pull the quantity on hand (QOH) from a table that contains QOH per year per period.  The set analysis below has multiple modifiers to filter the QOH for the year and period.  I'm not getting errors, but the result is 0 (zero).  I'm not sure where my set expression is failing.  Any assistance would be very much appreciated.


      Thank you in advance.



      =Num((Sum({$<FiscYear={$(=Max(FiscYear))}, FiscPer={$(=Max(FiscPer))}> } QtyOnHand)))