locked
BIDS Report Problem crm 2011 RRS feed

  • Question

  • Hi

    I created a report in BIDS. Iwant to get Total of Column (estimatedvalu) . I add geoup . add total

    =Sum(Fields!estimatedvalue.Value)

    but it gives error

    Total         #Error

    if any body have an idea plese help.

    thanks in advance

    Tuesday, June 12, 2012 6:45 AM

Answers

  • Hi

    I use

    =Sum(Fields!estimatedvalueValue.Value)

    instead of

    =Sum(Fields!estimatedvalue.Value)

    and is working

    • Marked as answer by Riaz Usmani Tuesday, June 12, 2012 8:13 AM
    Tuesday, June 12, 2012 8:13 AM

All replies

  • Make sure none of your EstimatedValue is null. If any of the records has a null value for EstimateValue, it would error.

    HTH

    Sam


    Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    • Proposed as answer by Sam - Inogic Tuesday, June 12, 2012 7:03 AM
    • Unproposed as answer by Riaz Usmani Friday, June 15, 2012 9:17 AM
    Tuesday, June 12, 2012 7:03 AM
  • Thanks for reply

    but if there no null value still it gives that error.

    Tuesday, June 12, 2012 7:51 AM
  • Hi

    I use

    =Sum(Fields!estimatedvalueValue.Value)

    instead of

    =Sum(Fields!estimatedvalue.Value)

    and is working

    • Marked as answer by Riaz Usmani Tuesday, June 12, 2012 8:13 AM
    Tuesday, June 12, 2012 8:13 AM