Home Forums Reporting Services Reporting Services 2008 Development SSRS textbox code not working properly RE: SSRS textbox code not working properly

  • December 27, 2014 at 9:38 am

    #1766560

    I am trending the current value on a chart. For example

    =IIF(Month(Parameters!EndDate.Value) > MAX(Fields!OrderMonth.Value),

    give me the current value by:

    Let say Goal = 1000

    Order month = month order was purchased

    12= total number of months per year

    (SUM(Fields!Goal.Value)/SUM(12 * MAX(Fields!OrderMonth.Value))),

    (SUM(Fields!Goal.Value)/SUM(12 * Month(Parameters!EndDate.Value)))