1 Reply Latest reply: Oct 18, 2012 9:45 PM by Thomas Skariah RSS

    need help with straight table expression

      Hi,

       

      In straight table i am using expression

       

      sum(InMonth(PeriodDate,setdateyearmonth('2000-01-01', vNextYearToSelected, 01) ,0,0) * -1 * [Actual] * Sign)

       

      to calculate the sum of Actual amount for January month, where vNextYearToSelected = 2012 and PeriodDate have values from Apr-2011 to Jun-2012.

      And actual selected year is 2011.

      Straight table is showing the data for all 12 months (Apr to Mar 12 columns) based on the year selection.

      Somehow this expression is not giving the right result, is there any modification required, please help me.