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) / How to select field am...
Microsoft Dynamics CRM (Archived)

How to select field amount using expression and minus that field amount from the total

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I am  working with SSRS reports.

upload-error.png

As show in above image, i need to select Refund total amount value and i need to minus that amount from total same for the Received and outstanding.

How i write expression for above condition in ssrs,or any other suggestion ? 

Thank you in advance.

*This post is locked for comments

I have the same question (0)
  • Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    How is the refund stored in the database. Based on the calculation it is calculating refund as a positive number, not a negative number to calculate the total, thus showing 7670 instead of 6670.

    If Refund is stored as a negative number in the database, the SUM should show the correct amount.

    As you are using CRM Online this is Fetch Xml Report, correct?

    Can you share your expression and format for the fields in the Total Amount Column, and the Grant Total Column?

  • Community Member Profile Picture
    Community Member on at

    If i want to select total amount whose charge type is refund then how i write expression for that??

    i tried below expression

    =IIf(Fields!psm_chargetype.Value="Refund",Fields!psm_totalamount.Value,Nothing)

    but it's not working

    For total i use

    =Sum(Fields!totalamountValue.Value)

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