web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Total Average of text ...
Microsoft Dynamics CRM (Archived)

Total Average of text box in ssrs report

(0) ShareShare
ReportReport
Posted on by Raviteja Reddy 280

I have been trying to get a total of a report, which couldn't be achieved using regular,

=Sum(Fields!SquareFt.Value)


as the main field value is being multiplied depending upon Notes. So the total isn't shown correct.

How can I fix this to get correct total.

report-comm.png

*This post is locked for comments

I have the same question (0)
  • Verified answer
    ram r Profile Picture
    ram r on at

    Easiest solution would be create another dataset without joining notes and get the sum from that dataset like Sum(Fields!FieldName.Value, "DatasetName").

  • Suggested answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,401 on at

    Did you consider, creating a sub-report with just that value and insert that sub-report in that cell.

  • The CRM Developer Profile Picture
    The CRM Developer 82 on at

    Hi Raviteja,

    I would suggest few things 

    1) In case you have a custom field named as 'Squareft' in Data Set

    If you do have such a custom field in your data set, then the field must be having some calculation too as your field value is being multiplied by notes.

    Suggestion: Here I would suggest you to use the native field or the original field from the data base or the attribute from the CRM (with which you must be multiplying the notes field) in the calculation  =Sum(Fields!SquareFt.Value) instead of the 'SquareFt' field.

    2) In case you don't have a custom field name 'Squareft' in Data Set

    If you don't have a custom field in named as 'Squareft' in Data Set then I will suggest you to have one.

    This field's expression should not have the calculation where you multiply the the OG attribute value with the notes.

    3) If 'Squareft' is  the original field 

    Kindly let me know if either of them does work for you.

  • Raviteja Reddy Profile Picture
    Raviteja Reddy 280 on at

    Thank you. Created a dataset to sum up the field values and used the expression in the total field

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans