14 Replies Latest reply: Sep 5, 2012 9:46 AM by Sagar Hussain RSS

    Help with Formula

      Hi

       

      I have the following formula:-

       

      sum({$<FiscalYear={2012}>}if (linetype='Invoiced',(val),0))

       

      this sets the year to being 2012 and gives me the sum of all lines invoiced...this is returning a different number to the following formula

       

      (if (linetype='Invoiced',(val),0))

       

      where I have selected the year 2012 from a list box...Any ideas why this should be happening?

       

       

      Thanks for any help!!