Question
3
Replies
87
Views
Blue Cross and Blue Shield of Minnesota
Posted: October 26, 2019
Last activity: February 17, 2021
Closed
Solved
group by in report def
I have a grid with number of columns displaying claims in rows:Claim Number | Pharmacy Name | Net Paid Amnt
Claim123 abc 2.25
Claim123 abc -2.25
Claim123 abc 2.25
Claim234 bcd 1.25
Requirement: I want to display...
Claim Number | Pharmacy Name | Net Paid Amnt
Claim123 abc 2.25
Claim234 bcd 1.25
...rolled up Net Paid Amt.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Thanks for reply Vikash.
I have 2.06, 2.06, -2.06. When I tried Sum, the report returns 4.12 and -2.06.
I can see it worked for you but not sure why it's not working for me. My netpaidamount is integer type. No custom code.
Hi Srikanth,
In report definition for any integer or currency field, you can follow the below approach:
I have created to work objects (net_amt=2.25,-2.25) whose sum will be 0.
In the report definition select Sum in the summarize field(Sum option will be present for integer or currency field but not for text field) :
NOTE: the Sort order should be set properly (in your case it should be 1 for claim no).
Regards,
Vikash