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

    Help with Formula

    Sagar Hussain



      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!!