Hello,
I am working with SSRS reports.
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
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)
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?
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
Victor Onyebuchi
6
Share
Report
All responses (
Answers (
