Question
3
Replies
77
Views
Blue Cross and Blue Shield of Minnesota
Posted: October 26, 2019
Last activity: October 28, 2019
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.
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