Applying formula to Column Values Within a Date Range

• NoviceJatt

  SSCommitted

  Points: 1671

  More actions

  July 30, 2010 at 4:08 pm

  #387475

  Hi

  I have a Report which I built in Report Builder 1.0 with 4 Columns: CP Code, Date, Sitename, Total Pageviews. I have attached an Image of my Report with this post.

  I have applied a filter on date that prompts me to select the date range for which I want to view the report. I want to add a column(Cost) to this report in report builder which calculates (Cost=(Total Pageviews/500)*5) for each CP code. But I want that when I run the report,The Cost Column Should Only show the Cost for the date range which I select from the drop down menu(Date Range Prompt).

  Can You guys give me the formula to do that?

  Thanks

• duggram

  SSC Rookie

  Points: 37

  More actions

  December 10, 2010 at 2:50 pm

  #1261224

  Any suggestions on a solution for the date range problem?